{"id":55,"date":"2024-06-03T07:17:40","date_gmt":"2024-06-03T07:17:40","guid":{"rendered":"http:\/\/blog.dynapictures.com\/?p=55"},"modified":"2026-07-21T11:34:15","modified_gmt":"2026-07-21T11:34:15","slug":"how-to-use-zapier-for-design-automation-with-dynapictures","status":"publish","type":"post","link":"https:\/\/blog.dynapictures.com\/how-to-use-zapier-for-design-automation-with-dynapictures\/","title":{"rendered":"How to Use Zapier for Design Automation with DynaPictures"},"content":{"rendered":"\n

Table of Contents<\/h2>\n\n\n\n

1. Overview<\/a><\/p>\n\n\n\n

2. What is Zapier?<\/a><\/p>\n\n\n\n

3. Create Zapier Account<\/a><\/p>\n\n\n\n

4. Prepare Your Image Template<\/a><\/p>\n\n\n\n

5. Create a Spreadsheet<\/a><\/p>\n\n\n\n

6. Create a  Zapier Automation (Zap)<\/a><\/p>\n\n\n\n

7. Configure Trigger to Start Automation<\/a><\/p>\n\n\n\n

8. Prepare Action to Generate an Image<\/a><\/p>\n\n\n\n

9. Save an Image to Google Drive<\/a><\/p>\n\n\n\n

10. Final Words<\/a><\/p>\n\n\n\n

11. Next Steps<\/a><\/p>\n\n\n\n

1. Overview<\/h2>\n\n\n\n

On this page, you will learn how to connect DynaPictures to Google Sheets and Google Drive with Zapier. We will focus on the integration with Google Sheets to specify personalized values for the image layers and on using Google Drive to store generated images in the end. <\/p>\n\n\n\n

Here is what we will get at the end:<\/p>\n\n\n

\n
\"Automate
Starting point of using Zapier for design automation<\/figcaption><\/figure>\n<\/div>\n\n\n

Warning:  As we will be creating a Zapier workflow with three actions, this requires you to be at least on the “Starter” plan at Zapier. If you don’t have it yet, you will be asked to upgrade on the final step. If you are happy with the free plan and don’t want to upgrade, just follow this tutorial till the end of the 8th step (8. Prepare Action to Generate an Image) and then click on the “Turn on Zap” button of the second step of the workflow (“Create Image”). Then you can add new rows to a spreadsheet, and access generated images either in the “Generated Images” section in DynaPictures or in the Zap history in Zapier.<\/p>\n\n\n\n

2. What is Zapier?<\/h2>\n\n\n\n

Zapier<\/a> lets you connect DynaPictures to 3,000+ other web services. Automated connections called Zaps, set up in minutes with no coding, can automate your day-to-day tasks and build workflows between apps that otherwise wouldn’t be possible. Each Zap has one app as the Trigger<\/strong>, where your information comes from and which causes one or more Actions<\/strong> in other apps, where your data gets sent automatically.<\/p>\n\n\n\n

3. Create Zapier Account<\/h2>\n\n\n\n

Sign up for a free Zapier<\/a> account here<\/a>.<\/p>\n\n\n\n

4. Prepare Your Image Template<\/h2>\n\n\n\n

Sign in<\/a> to DynaPictures and create your own image template by clicking on the first library template:<\/p>\n\n\n

\n
\"Create
Get started with the template library<\/figcaption><\/figure>\n<\/div>\n\n\n

Your image template will be created and the template editor will be opened. Check the checkbox “Sync to Zapier” to upload this image template to Zapier and be able to use it on the Zapier side in the next steps:<\/p>\n\n\n

\n
\"Sync
Sync template with Zapier<\/figcaption><\/figure>\n<\/div>\n\n\n

Please note the names of the following image layers on the left, as we will need to customize their values in the next steps:<\/p>\n\n\n

\n
\"Customize
Edit layers of the template<\/figcaption><\/figure>\n<\/div>\n\n\n

5. Create a Spreadsheet<\/h2>\n\n\n\n

We need a spreadsheet in order to specify personalized values for the image layers and then feed it to DynaPictures to generate hyper-personalized images.<\/p>\n\n\n\n

Let us create a new Spreadsheet in the cloud using Google Sheets and then connect it to DynaPictures via Zapier.<\/p>\n\n\n\n

Every image layer must have an individual column in the spreadsheet. Let’s enter the names of the image layers we want to customize in the first row of the newly created spreadsheet. Then let us also enter some test data, in the second row, as we will need it later to test our Zapier trigger.<\/p>\n\n\n\n

These are our spreadsheet columns, you can copy and paste this row directly as a first row into your spreadsheet:<\/p>\n\n\n\n

Name<\/td>Title<\/td>Text<\/td>Avatar Image<\/td><\/tr><\/tbody><\/table>
Here is our test data in the second row, you can copy and paste it directly into your spreadsheet:<\/figcaption><\/figure>\n\n\n\n
John Doe<\/td>Creator<\/td>Quote Text<\/td>https:\/\/dynapictures.com\/images\/banners\/cat1.jpeg<\/a><\/td><\/tr><\/tbody><\/table>
Our spreadsheet at the end:<\/figcaption><\/figure>\n\n\n
\n
\"Customize
Sample Spreadsheet with data for image personalization<\/figcaption><\/figure>\n<\/div>\n\n\n

6. Create a  Zapier Automation (Zap)<\/h2>\n\n\n\n

Zap is an automated workflow that may contain multiple steps. We will have these three steps in our Zap:<\/p>\n\n\n\n

1. Trigger: Google Sheets – New Row in a Spreadsheet<\/p>\n\n\n\n

2. Action: Generate a new image in DynaPicutres for the newly added spreadsheet row.<\/p>\n\n\n\n

3. Action: Upload the generated image to Google Drive<\/p>\n\n\n\n

Let’s open the Zaps page<\/a> in Zapier and then click on the button “Make a Zap”:<\/p>\n\n\n

\n
\"Make
Make a Zap to automate image creation<\/figcaption><\/figure>\n<\/div>\n\n\n

You can name this zap by clicking the “Name your zap” at the top left corner. We will name it “Quote 1”:<\/p>\n\n\n

\n
\"Continue
Name your Zap<\/figcaption><\/figure>\n<\/div>\n\n\n

7. Configure Trigger to Start Automation<\/h2>\n\n\n\n

The first step in this automation is to let Zapier know when it should launch it. It’s called a Trigger. Click on the text field “Search apps…”, start typing “Google Sheets” there and then select the Google Sheets app in the dropdown:<\/p>\n\n\n

\n
\"Continue
Configure a trigger<\/figcaption><\/figure>\n<\/div>\n\n\n

Then select “New Spreadsheet Row” from the dropdown “Trigger Event” and click the “Continue” button:<\/p>\n\n\n

\n
\"Connect
Choose a row from Spreadsheet<\/figcaption><\/figure>\n<\/div>\n\n\n

In the next step, you will be asked to connect your Google account. Choose an account from the dropdown if you already have one, or click on “Connect a New Account” otherwise. The Google authentication form will be shown in the popup and you will need to sign in and grant access to Zapier, and then click on “Continue”.<\/p>\n\n\n

\n
\"Customize
Connect your account<\/figcaption><\/figure>\n<\/div>\n\n\n

The next step for this trigger is to specify the spreadsheet and its worksheet to be used. Click on “Choose value…” in the “Spreadsheet” field and then select the spreadsheet “Quotes for DynaPictures”, this is a spreadsheet that we created in step #5.<\/p>\n\n\n

\n
\"Choose
Choose quotes for DynaPictures<\/figcaption><\/figure>\n<\/div>\n\n\n

Then select the first worksheet in this spreadsheet and click on the button “Continue”:<\/p>\n\n\n

\n
\"Select
Select a sheet<\/figcaption><\/figure>\n<\/div>\n\n\n

Finally, we can test our trigger by clicking on the button “Test trigger”.<\/p>\n\n\n

\n
\"Test
Testing rigger before generating images<\/figcaption><\/figure>\n<\/div>\n\n\n

You will see the confirmation message for the successful test. Congratulations! You have just configured your first trigger and can click on the button “Continue” and proceed to the next step now:<\/p>\n\n\n

\n
\"Select
Select corresponding rows<\/figcaption><\/figure>\n<\/div>\n\n\n

8. Prepare Action to Generate an Image<\/h2>\n\n\n\n

Once data is loaded from the spreadsheet in the first step, we will push this data to DynaPictures in this second step of our automated workflow.<\/p>\n\n\n\n

Start by typing “DynaPictures” in the App Event field and then select the DynaPictures app:<\/p>\n\n\n

\n
\"Prepare
Select DynaPictures in the App Event<\/figcaption><\/figure>\n<\/div>\n\n\n

Then select the “Create Image” action as an Action Event and click Continue:<\/p>\n\n\n

\n
\"Create
Choose an image in the Action Event<\/figcaption><\/figure>\n<\/div>\n\n\n

Now you need to add the DynaPictures API key to Zapier so that it can connect to DynaPictures with this key and make requests on your behalf. Start by clicking on the “Choose an account” and then on the button “+ Connect a new account”:<\/p>\n\n\n

\n
\"Choosing
Choose DynaPictures account <\/figcaption><\/figure>\n<\/div>\n\n\n

You will see a popup window with the API key field:<\/p>\n\n\n

\n
\"API<\/figure>\n<\/div>\n\n\n

Now let’s go back to the account page in DynaPictures, by clicking on your name in the upper right corner and then clicking on the Account:<\/p>\n\n\n

\n
\"Template
Find your DynaPictures account<\/figcaption><\/figure>\n<\/div>\n\n\n

Then you can copy your API key:<\/p>\n\n\n

\n
\"Copying
Copy the account number<\/figcaption><\/figure>\n<\/div>\n\n\n

Now go back to the Zapier popup, paste the key there and click on “Yes, Continue”:<\/p>\n\n\n

\n
\"Filling<\/figure>\n<\/div>\n\n\n

You will be taken back to the original Zapier window, where we configure our workflow. If the popup just closes and you don’t see it, you will need to find this window or tab in your browser, see that your account is connected and your email is shown in the account field, and then click on Continue:<\/p>\n\n\n

\n
\"Add
Add your copied account number to continue<\/figcaption><\/figure>\n<\/div>\n\n\n

Great, as Zapier can connect now to DynaPictures, it’s time to specify which design template we want to apply our personalization to. Click on “Choose value” in the Template field, and then select the image template. In our case it’s “Quote Blurred”:<\/p>\n\n\n

\n
\"Selecting
Selecting an image template<\/figcaption><\/figure>\n<\/div>\n\n\n

Once you select the template, Zapier will show the image layers and possible fields to customize. Now starts one of the most interesting parts of our tutorial – using the power of No-Code as we can glue two systems together by mapping columns from the spreadsheet to the image parameters without writing a single line of code.<\/p>\n\n\n\n

Skip the first layers and scroll down to the “Text” block and then click on this “Text” field there. You will see a list of columns from a spreadsheet with the sample values. Select the “Text” column there:<\/p>\n\n\n

\n
\"Spreadsheet
Selecting a Spreadsheet for image generation<\/figcaption><\/figure>\n<\/div>\n\n\n


Now scroll to the Avatar section, click on the Image URL form field and select the Avatar Image column:<\/p>\n\n\n

\n
\"Selecting
Selecting avatar image<\/figcaption><\/figure>\n<\/div>\n\n\n

Now let us scroll to the Name section, and select the Name spreadsheet column for the Text field:<\/p>\n\n\n

\n
\"Data
Inserting data for images<\/figcaption><\/figure>\n<\/div>\n\n\n

Then scroll to the Title section and map the Title field from the spreadsheet to the Text field in this section:<\/p>\n\n\n

\n
\"Mapping
Map the title field<\/figcaption><\/figure>\n<\/div>\n\n\n

We are done with mapping now and you can scroll down and click on the Continue button at the bottom.<\/p>\n\n\n\n

The final part of this step is to test and verify that your action works. Click on the “Test & Continue”:<\/p>\n\n\n

\n
\"Test
Test sending image to DynaPictures<\/figcaption><\/figure>\n<\/div>\n\n\n

You will see the success notification with the URLs of the generated test image. In our case it’s https:\/\/api.dynapictures.com\/images\/8eb9e4869b\/13add6dc53.png<\/a>:<\/p>\n\n\n

\n
\"Image
URL of the generated image<\/figcaption><\/figure>\n<\/div>\n\n\n

Well done, we are finished with this action now and can proceed to the final step in our tutorial.<\/p>\n\n\n\n

9. Save an Image to Google Drive<\/h2>\n\n\n\n

The final action in our workflow is to upload the newly generated image to the folder in Google Drive.<\/p>\n\n\n\n

As we will be adding a 3rd action to our workflow, this requires you to be at least on the “Starter” plan at Zapier. If you don’t have it yet, you will be asked to upgrade on the final step. If you are happy with the free plan and don’t want to upgrade, just click on the “Turn on Zap” button in the second step of the workflow (“Create Image”). Then you can add new rows to a spreadsheet, and see generated results either in the “Generated Images” section in DynaPictures or in the Zap history in Zapier.<\/p>\n\n\n\n

Let’s start by clicking on the plus icon at the very bottom:<\/p>\n\n\n

\n
\"testing
Successful test – image sent<\/figcaption><\/figure>\n<\/div>\n\n\n

The new workflow step with the action will be added and you need to type “Google Drive” into the App Event field, and then select the Google Drive app:<\/p>\n\n\n

\n
\"Type
Type “Google Drive”<\/figcaption><\/figure>\n<\/div>\n\n\n

Next, select the action that we want to be performed with Google Drive, let’s click on the “Upload File” action now:<\/p>\n\n\n

\n
\"Uploading
Choose Upload File<\/figcaption><\/figure>\n<\/div>\n\n\n

The next step is to connect Zapier to your Google Drive account so that Zapier is allowed to upload files to your Google Drive. Click on the button “Sign in to Google Drive” and then sign-in to Google Drive and grant access permissions to Zapier:<\/p>\n\n\n

\n
\"Signing
Sign in Google account to upload files<\/figcaption><\/figure>\n<\/div>\n\n\n

Once your Google Drive account is successfully connected, the popup window will be closed and you will see your email in the Google Drive account field of the form. You can click on the Continue button now.<\/p>\n\n\n

\n
\"Connected
Connected Google account<\/figcaption><\/figure>\n<\/div>\n\n\n

Now let’s select “My Google Drive” from the dropdown of the Drive field:<\/p>\n\n\n

\n
\"Choosing
Choosing a Google account to upload files<\/figcaption><\/figure>\n<\/div>\n\n\n

Then click on the File field of the form, click on the “Create Image in DynaPictures” step and then click on the “Show all options”:<\/p>\n\n\n

\n
\"Selecting
Create images in DynaPictures – Show all options<\/figcaption><\/figure>\n<\/div>\n\n\n

You will see all options now and then can select the Image URL field from data provided by DynaPictures:<\/p>\n\n\n

\n
\"Selecting
Selecting image URL<\/figcaption><\/figure>\n<\/div>\n\n\n

If needed, you can also select the destination folder, assign a custom file name, etc. For a custom file name, you will need another column in the spreadsheet, and then either map this column from the spreadsheet here into the filename field directly or pass it through DynaPictures via the Metadata parameter.<\/p>\n\n\n\n

The final part, as usual, is to verify that the action works as expected. Let’s click on “Test & Continue”.  You can go to your Google Drive folder after that and see the newly created image there:<\/p>\n\n\n

\n
\"testing
Testing the workflow<\/figcaption><\/figure>\n<\/div>\n\n\n

Finally, click on the “Turn on Zap” button:<\/p>\n\n\n

\n
\"testing
Confirmation of successful upload<\/figcaption><\/figure>\n<\/div>\n\n\n

That’s it! We have built our first workflow for design automation with DynaPictures! Now you can start adding new rows to your Spreadsheet and DynaPictures will generate personalized images automatically for you.<\/p>\n\n\n

\n
\"workflow
Ready workflow for automating image creation<\/figcaption><\/figure>\n<\/div>\n\n\n

10. Final Words<\/h2>\n\n\n\n

In case of troubleshooting or checking how your Zap works, you can go to Zaps on the left and then select “View Zap History” from the context menu:<\/p>\n\n\n

\n
\"View
View Zap history<\/figcaption><\/figure>\n<\/div>\n\n\n

11. Next Steps<\/h2>\n\n\n\n

We prepared some popular pre-made Zaps listed below, in case you need to integrate DynaPictures with other apps as well:<\/p>\n\n\n\n