Rapid Social Post Creation In Minutes w/ Chat GPT, Google Sheets, & Canva!
Make how-to guides like this one in a snap.
CS

Cynthia Schomp

Created Feb 20, 2023

Rapid Social Post Creation In Minutes w/ Chat GPT, Google Sheets, & Canva!

15
    c

Openai

4 Steps
1

Go to chat.openai.com

2

Click on New chat

This image is temporarily unavailable

Our servers may be down. Try waiting a few minutes before refreshing the page.
3

Type "write 30 posts about HVAC. Each post should be one sentence. It should be a fact or advise for customers about their home heating. Make each post start with a different word."

This image is temporarily unavailable

Our servers may be down. Try waiting a few minutes before refreshing the page.
4

Copy option

This image is temporarily unavailable

Our servers may be down. Try waiting a few minutes before refreshing the page.
    d

Google

8 Steps
5

Go to drive.google.com

6

Click on New

This image is temporarily unavailable

Our servers may be down. Try waiting a few minutes before refreshing the page.
7

Click on Google Sheets

8

Paste text area

This image is temporarily unavailable

Our servers may be down. Try waiting a few minutes before refreshing the page.
9

Click on application

This image is temporarily unavailable

Our servers may be down. Try waiting a few minutes before refreshing the page.
10

Type "HVAC Facts"

This image is temporarily unavailable

Our servers may be down. Try waiting a few minutes before refreshing the page.
11

Click on File

This image is temporarily unavailable

Our servers may be down. Try waiting a few minutes before refreshing the page.
12

Click on Download, then Comma Separated Values (.csv)

This image is temporarily unavailable

Our servers may be down. Try waiting a few minutes before refreshing the page.
    c

Canva

26 Steps
13

Go to www.canva.com

14

Click on Create a design

This image is temporarily unavailable

Our servers may be down. Try waiting a few minutes before refreshing the page.
15

Click on Create a design

You can alternatively open a premade template for your project. Skip to step 29 if you're not creating/editing a template.

This image is temporarily unavailable

Our servers may be down. Try waiting a few minutes before refreshing the page.
16

Click on Custom size

This image is temporarily unavailable

Our servers may be down. Try waiting a few minutes before refreshing the page.
17

Click on Width

This image is temporarily unavailable

Our servers may be down. Try waiting a few minutes before refreshing the page.
18

Type "1400"

This image is temporarily unavailable

Our servers may be down. Try waiting a few minutes before refreshing the page.
19

Click on Height

This image is temporarily unavailable

Our servers may be down. Try waiting a few minutes before refreshing the page.
20

Type "1400"

This image is temporarily unavailable

Our servers may be down. Try waiting a few minutes before refreshing the page.
21

Click on px

This image is temporarily unavailable

Our servers may be down. Try waiting a few minutes before refreshing the page.
22

Click on Create new design

This image is temporarily unavailable

Our servers may be down. Try waiting a few minutes before refreshing the page.
23

Click on Personal Brand Carousel Tips Instagram Post

This image is temporarily unavailable

Our servers may be down. Try waiting a few minutes before refreshing the page.
24

Click on Personal Brand Carousel Tips Instagram Post

This image is temporarily unavailable

Our servers may be down. Try waiting a few minutes before refreshing the page.
25

Click on one

This image is temporarily unavailable

Our servers may be down. Try waiting a few minutes before refreshing the page.
26

Type in highlight

This image is temporarily unavailable

Our servers may be down. Try waiting a few minutes before refreshing the page.
27

Drag highlighted text

This image is temporarily unavailable

Our servers may be down. Try waiting a few minutes before refreshing the page.
28

Type in social handle

This image is temporarily unavailable

Our servers may be down. Try waiting a few minutes before refreshing the page.
29

Click on tab Bulk Create

The first-time using bulk create in the account the option will be in the APPS tab.

This image is temporarily unavailable

Our servers may be down. Try waiting a few minutes before refreshing the page.
30

Click on Upload CSV

This image is temporarily unavailable

Our servers may be down. Try waiting a few minutes before refreshing the page.
31

Select "HVAC Facts - Sheet1.csv" from file upload menu

This image is temporarily unavailable

Our servers may be down. Try waiting a few minutes before refreshing the page.
32

Right click on Make sure your social media

This image is temporarily unavailable

Our servers may be down. Try waiting a few minutes before refreshing the page.
33

Click on Choosing the right size of HVAC system for your home is crucial to ensure efficient heating.

This image is temporarily unavailable

Our servers may be down. Try waiting a few minutes before refreshing the page.
34

Drag highlighted element (center it and make it fit the design)

This image is temporarily unavailable

Our servers may be down. Try waiting a few minutes before refreshing the page.
35

Click on text to make sure it's selected.

NOTE: Duplicate the PAGE so you don't accidentally lose the first row from the CSV file. If it's there twice delete it at the end. Canva is a little glitchy with this still.

This image is temporarily unavailable

Our servers may be down. Try waiting a few minutes before refreshing the page.
36

Click on Continue

This image is temporarily unavailable

Our servers may be down. Try waiting a few minutes before refreshing the page.
37

Click on Generate (29) pages

This image is temporarily unavailable

Our servers may be down. Try waiting a few minutes before refreshing the page.
38

Click on highlight

This image is temporarily unavailable

Our servers may be down. Try waiting a few minutes before refreshing the page.
Well done!
Create how-to guides like this in a snap. Get Tango now.