Add Infinite Options line items to Google Sheets

Setup is required before this template will work. Follow the steps below.

This workflow adds Infinite Options line items to an existing 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 Row Create 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. View this Google Sheets spreadsheet and click Make a Copy. Feel free to rename it to your preferred title. 

3. Update the last two columns' headers of the spreadsheet (i.e. infinite_options_1 and infinite_options_2) to match the actual  Label on Carts that you set up in Infinite Options.

Add one column header for any additional Infinite Options' Label on Carts that you would like to save in your spreadsheet.

4. Go back to the workflow and on the Google Sheets Create Row step locate the Spreadsheet field. Click on it and click on the title of your copied Spreadsheet

The Sheet Name will be Sheet 1 for the standard copy.

5. After adding any additional column headers, click on the Retrieve Spreadsheet Columns button to bring in the additional column headers to the workflow.

6. Update the Tokens for your Infinite Options fields. These tokens will be something like {{iterator.fields.infinite_options_1}}, where infinite_options_1 is the Label on Cart in your Infinite Options Option Set configuration.

If your Label on Cart contains spaces, you will need to use this token format (Scent Selection 1 is the example Label on Cart): {{iterator.fields['Scent Selection 1']}}

For more information on updating your Google Sheets Row Create step after adding additional fields to the spreadsheet, follow this guide.

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

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