# Generate design variations through a spreadsheet

Organize your data in a spreadsheet and automate your creatives' generation when you add a new row of data. The spreadsheet should contain the details you want to include in your creative, like headline, image link, and other texts and details which will replace the layers in an existing design from your Creatopy account that you'll use as a template in Zapier. 

Zapier integrates with many sheet apps. You can take a look at the article below. 

{% embed url="<https://zapier.com/apps/categories/spreadsheets>" %}

We'll use Google Sheets as an example, but it will work similarly with any other spreadsheet app that integrates with Zapier. You will need to set up a trigger and an action in a zap to create this workflow.&#x20;

### Setting up the trigger

First, set up the trigger by selecting the Google Sheets app and picking the **New Spreadsheet Row** event.

<figure><img src="/files/9gwbffR8aaKwCLTYz5U3" alt=""><figcaption></figcaption></figure>

Subsequently, connect your Google account so it accesses your Google Drive. Then, pick the spreadsheet and worksheet you want to use.

<figure><img src="/files/LFhzSQALLfOB9HpVwDKq" alt=""><figcaption></figcaption></figure>

Your spreadsheet has to have column headers. To test the trigger, add a new row with data to your spreadsheet and return to Zapier to test it.

{% hint style="info" %}
Make sure your spreadsheet has column headers for Zapier to read the data in your spreadsheet correctly.&#x20;
{% endhint %}

### Setting up the action

In the second step of the zap,  add the Creatopy Zapier app and choose the event **Generate creative**, like in the screenshot below.

<figure><img src="/files/HkGAzxDkg4bwXPJsZeBD" alt=""><figcaption></figcaption></figure>

If you haven't yet connected your Creatopy account to Zapier, you'll have to go to Creatopy and generate the API keys needed to authenticate in Zapier and use the Creatopy app. You can find how to do all that in the link below.

{% content-ref url="/pages/qDM8wRBzCUW7ZC8v8iBo" %}
[Zapier integration](/zapier-integration.md)
{% endcontent-ref %}

Continuing with the zap, you'll have to pick a design template for the generated variations, the type of export, and the webhook URL that will be called when Creatopy finishes generating the variant. You can see below how to set up a webhook trigger or leave this field empty and set a second zap using the Creatopy trigger to send the generated creatives to your inbox or cloud storage.&#x20;

{% content-ref url="/pages/nlE8bhjZGfLh8SCGkmIX" %}
[Webhook trigger](/zapier-integration/setting-up-zapier-with-the-brief/setting-up-your-second-zap/webhook-trigger.md)
{% endcontent-ref %}

When you pick a template, Zapier will list the layers in your design template, which you need to map to your input fields (the data in your spreadsheet based on your column headers).&#x20;

<figure><img src="/files/gUoMRGftTSdGiDhZ9lxy" alt=""><figcaption></figcaption></figure>

Finally, test the action to ensure everything is fine; you will get a message with a pending status, as shown below.

<figure><img src="/files/vRoUmP9H34jH3P8dDVZo" alt=""><figcaption></figcaption></figure>

To put this workflow live, you have to publish the zap.&#x20;

Here are a few use cases on what to do with your newly generated creatives:

{% content-ref url="/pages/6skYHVETomiTl9Cb7R03" %}
[Send newly generated creatives to cloud storage](/zapier-integration/zapier-use-cases/send-newly-generated-creatives-to-cloud-storage.md)
{% endcontent-ref %}

{% content-ref url="/pages/FXindEEyDbGxlSvcnbHC" %}
[Send newly generated creatives to an email inbox](/zapier-integration/zapier-use-cases/send-newly-generated-creatives-to-an-email-inbox.md)
{% endcontent-ref %}

{% content-ref url="/pages/wuqfQ5BH8QEBY2egVNVW" %}
[Post newly generated creative on a social media platform](/zapier-integration/zapier-use-cases/post-newly-generated-creative-on-a-social-media-platform.md)
{% endcontent-ref %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.thebrief.ai/zapier-integration/zapier-use-cases/generate-design-variations-through-a-spreadsheet.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.