How to export my responses to Google Sheets?

This feature is only available for PRO+ subscriptions and you need to have a Zapier account and your evalandgo API key configured.

Step 1: Prepare your Google Sheets file

1. Create a new Google Sheets file

2. Name your columns based on the data you want to collect

Good to know: column names must be clear, as you will map them later in Zapier.

Example:

If your question is “Are you an individual or a professional?”, you can name your column:

- individual or professional

- or use the exact question wording

Step 2: Configure export via Zapier

1. Go to your questionnaire

2. Open the Results tab

3. Click on Export

4. Select Google Sheets via Zapier

👉 A new tab opens in Zapier

Step 3: Set up the trigger

1. Log in to your Zapier account

2. A preconfigured Zap is available with:

- Trigger: New Questionnaire Completed (Evalandgo)

- Action: Create Spreadsheet Row (Google Sheets)

3. In the trigger:

- Connect your evalandgo account using your API key

- Click Continue

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

Good to know:

The questionnaire ID is visible in the publication URL.

4. Click Test Trigger

Step 4: Configure Google Sheets action

1. Connect your Google account

2. Select:

- Your Drive

- The spreadsheet

- The sheet

3. In the Configure section:

- Your columns will appear automatically

- Map each column to a questionnaire answer

Example:

Column individual or professional

→ Map to the question “Are you an individual or a professional?”

4. To insert data:

- Click the + button

- Select the corresponding field

5. Click:

- Continue

- Test Step

- Publish

Result

Once your Zap is active:

- Each new response will be automatically sent to your Google Sheets

- Data is added in real time, row by row

Only responses collected after activation will be exported.

Need help?

Our team can assist you in setting up your automation.