How do I automatically export my responses to Google Sheets?

This action requires a Make or Zapier account, a PRO+ subscription and the setup of an API key :

Do you want to feed a Google Sheets file in real time with your questionnaire responses?

This is possible through an automation using Zapier. Here is how to do it easily.

Step 1: prepare your Google Sheets

1. Create a new Google Sheets file.

2. Name the columns according to the data you want to retrieve.

Good to know: column names must be clear, as you will match them to the responses in Zapier.

Example: if you have a question "Are you an individual or a professional?", you can create a column:

- "individual or professional";

- or use the exact wording of the question.

Step 2: set up the export via Zapier

1. Go to your questionnaire.

2. Click on the Results tab.

3. Click on Export.

4. Select Google Sheets via Zapier.

👉 A new tab opens on Zapier.

Step 3: configure the trigger

1. Log in to your Zapier account.

2. A preconfigured Zap is offered with:

- Trigger: New Questionnaire Completed (Evalandgo);

- Action: Create Spreadsheet Row (Google Sheets).

3. In the trigger:

- Connect your Evalandgo account with your API key;

- Click on Continue;

- The questionnaire is selected automatically (via its ID, for example: 123456).

Good to know: the questionnaire ID is visible in the questionnaire's distribution URL.

4. Click on Test Trigger to check that the data is retrieved.

Step 4: configure the Google Sheets action

1. Connect your Google account.

2. Select:

- the Drive;

- the Google Sheets file;

- the relevant sheet.

3. In the Configure section:

- the columns of your Google Sheets appear automatically;

- match each column to a response.

Example:

Column "individual or professional"

→ Match it to the question "Are you an individual or a professional?"

4. To add a piece of data:

- Click on the + button to the right of the field;

- Select the corresponding data.

5. Click on:

- Continue;

- Test Step;

- Publish.

Result

Once your Zap is activated:

- each new completed response will be automatically sent to your Google Sheets;

- the data will be added row by row, in real time.

Only responses collected after the Zap is activated will be exported.

Need help?

Our team can assist you in setting up your automation.

How to export my responses to Google Sheets?