Add a post-purchase survey form and send results to Google Sheets

🔧 Setup is needed:
🔌 Connect with Google Sheets
✏️ Create your spreadsheet
➕ Add post-purchase survey form
✅ Save and enable your workflow to start automating!

This template will collect responses from a post-purchase survey via Forms by MESA and sends the responses for each submission to a Google Sheets spreadsheet.

Let's get started 🚀

Follow the steps below to set up this workflow.

1. In the Google Sheets Row Create step, click the Authenticate with Google button to create a new Credential and authenticate with Google.

If you have already created a Credential, select an existing one in the Existing Credentials drop-down menu. Then, hit the Done button.

2. In the Step Configuration section, select Create new and add a spreadsheet name. 

Click the Create Spreadsheet button to create a new spreadsheet on your Google Sheets account.

3. The Select Spreadsheet field will display with the title of the new spreadsheet. Click the external link icon to the right of the search bar to view your new spreadsheet in Google Sheets.

4. Go back to the workflow and hit the Save button at the top of the workflow before proceeding to the next step.

5. Click on the Done button in the Step Configuration section.

6. Open the Form trigger. Copy the Form Embed Code by clicking on the copy icon.

7. From the Shopify Admin, click on Settings and then Checkout and accounts.

8. Paste the copied form code in the Order status page field under the Additional Scripts section. Then, click on Save.

9. Go back to your workflow. Click on the Done button in the Form trigger.
10. At the top of or below the workflow, hit the Save button to save your changes.

11. Hit the toggle to switch it to On when you are ready to start using the workflow.

12.⚡️ See your workflow in action!

  • Navigate to your Orders in the Shopify admin.
  • Select an Order.
  • Select More Actions from the drop-down menu in the right-hand corner.
  • Select the View Order Status Page.

Your survey will appear at the top of the confirmation page. Go ahead and provide a response in the feedback form and see your response in the spreadsheet. 

✋ Still have questions? We got you. Email us at contact@getmesa.com where actual humans are on standby 24/7, ready to help.