Add product options to Google Sheets

This template will: 

  • Add product options from Infinite Options to a Google Sheets spreadsheet when a Shopify order is created.

๐Ÿ”ง  Setup is needed:
๐Ÿ”Œ  Connect with Google Sheets
โž•  Add product options
โœ…  Save and enable your workflow to start automating!

๐ŸŽฅ Watch how to add product options to Google Sheets with a new spreadsheet:

Follow the steps below to set up this workflow.

Step 1

In the Infinite Options Order Created trigger, click the Done button.

We're purposely leaving the field blank to return all product options.

Step 2

In the Google Sheets Create Row step, select an existing credential or click the Connect with Google button to connect Google Sheets with MESA.

Step 3

In the Step Configuration section, create a new Google Sheets spreadsheet. 

Select Create new under the Spreadsheet field and add a spreadsheet name. 

Step 4

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

Step 5

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.

Step 6

Scroll to the right of the spreadsheet until you see the "Product Price" column header. 

Add additional column headers after "Product Price" to the spreadsheet that match the Label on Cart(s) that you set up in Infinite Options (i.e. Scent Selection 1, Scent Selection 2).

Step 7

Return to your MESA workflow and click 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 8

Scroll down to the bottom of the Columns section and add the variables for your Infinite Options fields by clicking the Variable selector icon {+}. 

The variable selector will appear on the right-hand side of your screen.

Select a variable from under the Loop icon that represents the option selections.

Step 9

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

Step 10

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

Step 11

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

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