Google Sheets

Use the Google Sheets node to automate work in Google Sheets, and integrate Google Sheets with other applications. Localmind Automate has built-in support for a wide range of Google Sheets features, including creating, updating, deleting, appending, removing and getting documents.

On this page, you'll find a list of operations the Google Sheets node supports and links to more resources.

Credentials

Refer to Google Sheets credentials for guidance on setting up authentication.

Operations

• Document
  • Create a spreadsheet.
  • Delete a spreadsheet.
• Sheet Within Document
  • Append or Update Row: Append a new row, or update the current one if it already exists.
  • Append Row: Create a new row.
  • Clear all data from a sheet.
  • Create a new sheet.
  • Delete a sheet.
  • Delete Rows or Columns: Delete columns and rows from a sheet.
  • Get Row(s): Read all rows in a sheet.
  • Update Row: Update a row in a sheet.

Related resources

Refer to Google Sheet's API documentation for more information about the service.

<!-- ## Examples This example uses the Customer Datastore node to provide sample data to load into Google Sheets. It assumes you've already set up your credentials. 1. Set up a Google Sheet with two columns, test1 and test. In test1, enter the names from the Customer Datastore node:
2. Create the workflow: use the manual trigger, Customer Datastore, and Google Sheets nodes.
3. Open the Customer Datastore node, enable Return All, then select Test step. 4. In the Google Sheets node, go through the steps above, using these settings: * Select Update Row as the Operation. * In Column to Match On, select test1. * For the first field of Values to Update, drag in the name from the input view. * For the second field of Values to Update, drag in the email from the input view. 5. Select Test step. 6. View your spreadsheet. test2 should now contain the email addresses that match to the names in the input data.

Common issues

For common questions or issues and suggested solutions, refer to Common issues.

What to do if your operation isn't supported

If this node doesn't support the operation you want to do, you can use the HTTP Request node to call the service's API.

You can use the credential you created for this service in the HTTP Request node:

1. In the HTTP Request node, select Authentication > Predefined Credential Type.
2. Select the service you want to connect to.
3. Select your credential.

Refer to Custom API operations for more information.