Rapid Social Post Creation In Minutes w/ Chat GPT, Google Sheets, & Canva!
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

Click on New chat
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."

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."
4

Copy option

Copy option
    d

Google

8 Steps
5

Go to drive.google.com

6

Click on New

Click on New
7

Click on Google Sheets

8

Paste text area

Paste text area
9

Click on application

Click on application
10

Type "HVAC Facts"

Type "HVAC Facts"
11

Click on File

Click on File
12

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

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

Canva

26 Steps
13

Go to www.canva.com

14

Click on Create a design

Click on Create a design
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.

Click on Create a design
16

Click on Custom size

Click on Custom size
17

Click on Width

Click on Width
18

Type "1400"

Type "1400"
19

Click on Height

Click on Height
20

Type "1400"

Type "1400"
21

Click on px

Click on px
22

Click on Create new design

Click on Create new design
23

Click on Personal Brand Carousel Tips Instagram Post

Click on Personal Brand Carousel Tips Instagram Post
24

Click on Personal Brand Carousel Tips Instagram Post

Click on Personal Brand Carousel Tips Instagram Post
25

Click on one

Click on one
26

Type in highlight

Type in highlight
27

Drag highlighted text

Drag highlighted text
28

Type in social handle

Type in social handle
29

Click on tab Bulk Create

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

Click on tab Bulk Create
30

Click on Upload CSV

Click on Upload CSV
31

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

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

Right click on Make sure your social media

Right click on Make sure your social media
33

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

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

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

Drag highlighted element (center it and make it fit the design)
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.

Click on text to make sure it's selected.
36

Click on Continue

Click on Continue
37

Click on Generate (29) pages

Click on Generate (29) pages
38

Click on highlight

Click on highlight
Well done!
Create how-to guides like this in a snap. Get Tango now.