Add a Shopify customer to Google Sheets

This template will: 

  • Add a Shopify customer to Google Sheets when a customer is created in Shopify

๐Ÿ”ง  Setup is needed:
๐Ÿ”Œ  Connect with Google Sheets
โœ๏ธ  Create your spreadsheet
โœ…  Save and enable your workflow to start automating!


Follow the steps below to set up this workflow.

Step 1

In the Google Sheets Add Row step, click on the Authenticate with Google button to create a new credential or select an existing credential from the drop-down menu. Click Done.

Step 2

In the Step Configuration section, select Create new under the Spreadsheet label and add a spreadsheet name. 

Step 3

Click on the Create Spreadsheet button to create a new Google Sheets spreadsheet with column headers.

Step 4

The Select Spreadsheet field will display 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.

Step 5 (Optional)

Feel free to make changes to the column headers' titles in your spreadsheet.

Step 6

If changes were made in the spreadsheet, return to the workflow and click on the Update Spreadsheet Columns button to apply the changes to the workflow.

๐Ÿ—’ Note: Anytime you make additional changes on the Google Sheets spreadsheet, like changing the title or column headers, you'll need to click the Update Spreadsheet Columns button again to apply them to the workflow.

Step 7

Under the Columns section, scroll down and locate your new or changed column headers. 

You will see a field under the column header. Click on the Token selector menu icon {+} and select the Token that represents the value. 

Step 8

Click on the Done button at the top or bottom of the Step Configuration section.

Step 9

At the top of or below the workflow, click the Save button to save your changes.

Step 10

Click the toggle to switch your workflow On when you are ready to start automating.

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