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

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

Creation Date: February 20, 2023
Created By: Cynthia Schomp

2. Click on New chat

Click on New chat

3. Type “write 30 posts about HVAC (your topic). 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

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)

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


The Free Resources
To Help You Sell Online.

Tutorials, resources, & support in a community setting to help you monetize your online presence & launch profitable income streams! All members get access to our signature program social media stars!

Day Rates, Packages, & Retainers

Let me support you with your graphics, website, social media, content creation, & any creative or technical work you might need!