Zapier action element (example)

From Quentn to Google Spreadsheet via Zapier

In the following example, we show you how you can link your Quentn account to Google spreadsheet via Zapier. Let's say you have a form on your website, which visitors use to subscribe to your newsletter. You want every new contact to be automatically entered into a Google spreadsheet table, without having to do anything. 

Step 1: Create Zap

The first step is to log into the Zapier website and create a new Zap. As the trigger, select the Quentn.com app and follow the instructions via "Campaign contact" until you finally arrive at "Connect an account". A new window will open when clicked on, allowing you to connect your Zap to your Quentn account. 

Step 2: Connect Zap with Quentn

There are two essential values of which you must inform Zapier: the API URL and the API key. You will find both in your Quentn account under My account -> API info -> Zapier API. Copy both values into the corresponding fields in Zapier and follow the further instructions. 

Step 3: Link element ID

In the campaign for which you created the registration form, drag the action element "Send Zapier" to the Campaign Builder. Give the element a name so you can find it in Zapier! Then switch to Zapier and select the corresponding element.

Step 4: Select spreadsheet as the goal 

If you now follow the instructions on the Zapier website, you will be able to configure the trigger part of your Zap and can now continue with the action part. Select "Google Spreadsheet" as the app and "Create spreadsheet row" as the action. This means that a new row with the contact information will be added to the spreadsheet as soon as a new contact is sent from Quentn to Zapier. For the sake of simplicity, we will only use the two fields "Name" and "Email" here. Of course, you can add as many fields as you like.

Step 5: Connect Zap with your Google account and create a spreadsheet if necessary

The next step is to connect your Google account to Zapier. Follow the instructions again. If not yet available, you should create a spreadsheet and preferably give the columns a heading. In our example, "Name" and "Email".

Step 6: Assign spreadsheet table and fields 

Returning to Zapier's website, select the table under "Spreadsheet" in the dropdown menu and the corresponding spreadsheet under "Worksheet". If this has been done correctly, you will see the existing column headings and can allocate the forwarded fields to them. Now all you have to do is follow the instructions, name and activate the Zap and you're done.