Creating Canva posts using Google Sheets

You can solve this using Zapier by following these steps:

1. Trigger: Pull Data from Google Sheets

• Trigger App: Google Sheets
• Trigger Event: New or Updated Spreadsheet Row
• Setup: Choose the spreadsheet and worksheet where your data is stored. Ensure that your placeholder values (like {Name}, {Price}, {Date}) are present in your Canva template and match the column names in Google Sheets.

2. Action: Replace Placeholders in Canva Design

• Action App: Canva
• Action Event: Create Image (Beta)
• Setup:
  • Select your existing Canva template.
  • Map each placeholder in Canva to the corresponding data column from Google Sheets.
  • Example: If {Name} is a placeholder in Canva, assign it the value from the "Name" column in Google Sheets.
  • Ensure the font, size, and alignment match your expectations.

When I try to choose an Action event on Zapier, I do not see ‘Create Image’ as one of the options. The ones that I have are as follows:

Create Design

Export Design

Import Design

Move Folder Item

Upload Asset

API Request (Beta)

Find Design

Get Asset Upload Job

Get Design Upload Job

Get Design Export Job

Get Design Import Job

Would any of these be useful in doing what I’m trying to do?

Yes! The "Create Design" action is the one you need.

The Create Design action does not allow me to add text boxes as assets to the design, I can only add images to the new Canva design being created. Can you explain how that might be possible?

Yes, after researching, you’re right—Zapier does not support dynamic text replacement in Canva. You'll need to either:

Try other platforms like Make.com, which has more advanced Canva integrations.

Use Canva’s API to modify text dynamically within a design.

Hi ​@autodidact,
 
We just wanted to see how everything is going with your Zap. Did Hafiz's recommendation get the job done? Feel free to reach out if you need further assistance with your Zap. We're glad to address any concerns and assist you.
 
We're looking forward to your response.