0

Google Sheets connector

What is Google Sheets?

You can create, edit, share spreadsheets on-the-go and receive automated insights from your data via Google Sheets.

About Kissflow's Google Sheets integration

The Google Sheets connector from Kissflow Integration enables you to connect Google Sheets instantly and to automate your work with other Kissflow apps and popular third party apps. You must have a valid Google account and be a paid Kissflow customer in order to integrate with Google Sheets. To perform specific actions, use the Google Sheets connector to receive data from other flows or apps. For now, the connector for Google Sheets does not support any trigger events.

Actions in Google Sheets connector

Action events

Description

Create a spreadsheet

This action creates a blank spreadsheet or duplicates an existing spreadsheet. You can optionally provide headers.

Create a worksheet

This action creates a blank worksheet with a title. You can optionally provide headers.

Create a row

This action creates a new row in a specific spreadsheet

Update a row

This action updates a row in a specific spreadsheet

Lookup spreadsheet row

This action finds a row by a column and value. It also returns the entire row if one is found.

Google Sheets connector as an action step

  1. Inside your Kissflow account, click your profile picture on the top right corner of the screen and click Integrations from the dropdown. Now, click the New integration button to provide a name and description for your integration.
  2. Once inside your editor, set up a trigger step, for example, a Kissflow Process trigger event, When an item is created.
  3. After setting up your trigger step above, click the Add button (

     ) next to set up your action step. Search for Google Sheets and select a desired action.

     

  4. After choosing your action event, authenticate the connector. Click +Add an account and sign in using your Google account. Kissflow uses Google's OAuth for authentication.
  5. After authenticating with your Google account, add relevant values against the Google Sheets form fields. You can hit Refresh fields to view all the updated fields in the selected Google Sheets form. You can also map Google Sheets fields from your trigger step or fields from your previous action steps. These values will be automatically added to item fields after the action is executed.

     

  6. After a successful configuration, test whether your Google Sheets action step is set up correctly by clicking the Test button. The connector will pull field data from your selected Google account and display it as a JSON output. Similar to trigger step, errors are notified to you right away. Fix them before retesting the action step.

Setting up a Google Sheets connector

After creating a custom workflow with your Google Sheets connector's action steps, switch ON the toggle button to activate the integration run. Once a trigger event occurs, the Google Sheets' actions are activated.