Skip to main content
Best answer

How do I automate Pinterest pin creation with images & texts from a spreadsheet?

  • October 18, 2023
  • 5 replies
  • 714 views

I'm trying to automate pin creation for Pinterest using Canva (but I can consider any alternative).

 

I have 1 template that I want to use for different images and texts.

I have a spreadsheet with the following columns:
1. a link to the image file on Google Drive

2. Text for the design

3. Text for the Pin heading

4. Text for the Pin description

I know automating the texts is easy, but I would love to know if I can also automate the images. Or must I add them manually?

Thanks a lot!

Best answer by SamB

Hi there, @pazitive

Troy is correct here. Canva isn’t available to use in a Zap at present, but it is on our internal wishlist of apps to have added to Zapier. So I’ve added your vote for it. While we can’t make any promises as to when or whether it will definitely be added, I can promise that we’ll let you know once it is! 

In the meantime, you could try an app like Bannerbear as Troy mentioned, although that wouldn’t generate the image using Canva specifically. As an alternative I’m thinking that since you’ve already got a spreadsheet with details of all the image files you wish to create in Canva it might be worth converting that into a CSV file to use with Canva’s Bulk Create option. You can see more about how create Canva designs in bulk here: https://www.canva.com/help/bulk-create/

Hope one of those workarounds will do the trick for now. Would love to know whether you find an alternative solution too so please do keep us updated on how you get on with this! 🙂

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

5 replies

communitymember
Forum|alt.badge.img+2

Did you tried it out? @pazitive 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • October 18, 2023

Hi @pazitive 

Good question.

The Zap action for Pinterest - Create Pin has these fields:

 


  • Author
  • Beginner
  • October 18, 2023

Hi @pazitive 

Good question.

The Zap action for Pinterest - Create Pin has these fields:

 

Thank you for your reply!

I think you might haven’t understand what I’m trying to do (or I might have misunderstood your answer) - before scheduling pins, I need to create the designs first. 

I have a spreadsheet and in every row there is: 

a link to an image in Google Drive

text for the image

^^^ these two are for the design

text for pin heading

text for pin description

^^^ these are for scheduling

 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • October 18, 2023

@pazitive 

There is no Zap app available for Canva, so you’ll have to see alternatives such as Bannearbear.


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • Answer
  • October 19, 2023

Hi there, @pazitive

Troy is correct here. Canva isn’t available to use in a Zap at present, but it is on our internal wishlist of apps to have added to Zapier. So I’ve added your vote for it. While we can’t make any promises as to when or whether it will definitely be added, I can promise that we’ll let you know once it is! 

In the meantime, you could try an app like Bannerbear as Troy mentioned, although that wouldn’t generate the image using Canva specifically. As an alternative I’m thinking that since you’ve already got a spreadsheet with details of all the image files you wish to create in Canva it might be worth converting that into a CSV file to use with Canva’s Bulk Create option. You can see more about how create Canva designs in bulk here: https://www.canva.com/help/bulk-create/

Hope one of those workarounds will do the trick for now. Would love to know whether you find an alternative solution too so please do keep us updated on how you get on with this! 🙂