Add product options to Google Sheets

🔧 Setup is needed:
🔌 Connect with Google Sheets
➕ Add product options
✅ Save and enable your workflow to start automating!

This template will add product options from Infinite Options to a Google Sheets spreadsheet when an order is created.

Let’s get started 🚀

Follow the steps below to set up this workflow.

1. Open the Google Sheets Create Row step and 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.

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

Select Create new under the Spreadsheet field and add a spreadsheet name. Click on the Create Spreadsheet button to create a new Google Sheets spreadsheet with column headers.

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.

3. Scroll to the right of the spreadsheet till 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).

4. Go back 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. 

5. Scroll down to the bottom of the Columns section and add the Tokens for your Infinite Options fields by clicking the token selector {+} icon. A menu will pop up on the right-hand side and under the Loop icon, select from the list of Tokens that represent the option selections.

6. At the top of the workflow, hit the Save button to save your changes.

7. Hit the Enable button when you are ready to start using the workflow.

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