Google Sheets

Heads Up!

Check out our newest app, InstaSheets for much more Google Sheets functionality.

Arigato Automation has two actions to send data to Google Sheets. Information about each action type and when to choose one over the other is detailed below.

Step 1. Enable the Google Sheets Integration

Before you can use the Google Sheets actions you will need to allow the app to access your sheets. In the app, go to the "Integrations" page and find the "Google Sheets" integration. Click "Enable" on the integration.

On the following page click the "Grant Google Sheets Access" button.

Screenshot_2020-04-30_12.34.51.png

You will be asked to sign into the Google account you want to use. You will only be able to send data to Google Sheets you have "edit" permissions on.

After allowing access you should see "Google Sheets integration is currently enabled."

Screenshot_2020-04-30_12.36.01.png

Now you're ready to use the Google Sheets actions!

Add multiple rows to a Google Sheet (Advanced)

This action is more complex than the other Google Sheets action because you can add multiple rows to a sheet and requires some simple code manipulation.

First, we need to copy & paste the URL to a Google Sheet we want to send data to. After pasting in a URL click "Verify Sheet".

Screenshot_2020-04-30_12.39.52.png

In the "Cell Values" field click the {t} button to open the Token Browser. From there you can select data points to send to the Google Sheet.

Screenshot_2020-04-30_12.44.56.png

Multiple Rows

If you want to send multiple rows to a Google Sheet, such as sending all order line items, you can select a line item values from the Token Browser to have a loop created for you automatically. You can then use the special #NEWROW# tag to signify that you want a new row created per loop. For example:

{% for line_item in order.line_items %}<br> {{ order.id }}<br> {{ order.name }}<br> {{ line_item.title }}<br> {{ line_item.variant_title }}<br> {{ line_item.sku }}<br> {{ line_item.quantity }}<br> {{ line_item.final_line_price }}<br> #NEWROW#<br>{% endfor %}

Additional Notes & Considerations 

  1. This action cannot update existing rows in the sheet, it can only insert new rows.
  2. The first cell value must not be blank. It is recommended to use an ID for the first cell value.
  3. Cell ranges in the sheet must not be protected. For example, if you are trying to insert a value into column E, and column E is a protected range, the action will fail. 
  4. Your Google account must have access to "edit" the sheet.

Insert or Update One Row in a Google Sheet

This action allows you to insert or update a single row in a Google Sheets based on a unique ID in the row. This action cannot be used to insert multiple rows, such as a list of product variants, or order line items. To insert multiple rows you must use the "Advanced" action documented above.

First, copy & paste the Google Sheet URL as documented above.

You can select whether or not you want to just insert rows or also update them based on a primary key. It is recommend to set the first cell value as an ID, and set the Primary Key value to Cell A.

Screenshot_2020-04-30_12.58.14.png

You can enter cell values by opening the Token Browser by pressing the {t} button.

Screenshot_2020-04-30_12.59.48.png