With Google Spreadsheet, you can add, update and look up your data in a spreadsheet as well as process the data with various built-in tools with Google.

Introduction

With recent updates to Google Integrations, the process for connecting Google Sheets has changed slightly. Here’s a step-by-step guide to ensure a seamless connection to Google Sheets from your dashboard.

Step 1: Navigate to the Integrations Section

1. From your Dashboard Overview, locate the left-hand menu.

2. Click on Integrations.

3. Select Google Sheet from the list of available integrations.

Open

Step 2: Disconnect (If Already Connected)

• If you’re already connected to Google Sheets, click Disconnect to remove the existing integration.

• This ensures a fresh setup.

Step 3: Sign in with Google

1. Click on the Sign In with Google button.

2. Choose the Google account you’d like to connect.

3. Complete the sign-in process.

You’ll be redirected back to the integration setup.

Open

Step 4: Add Your Google Sheets

Previously, sheets were added directly inside workflows. Now, you’ll need to link them at this stage.

1. Add Sheet by URL:

   • Paste the URL of the Google Sheet you wish to connect.

   • Assign a name for easy identification.

2. Add Sheet Directly:

   • Click Add Sheet and browse your available Google Sheets.

   • Select the sheet you want to connect.

The selected sheet will now be available for use in your flow automations.

Once Sheets are added, you can see them here and also access them in the flow builder. 

Manage Spreadsheet in Action Step

In an Action step, follow steps 1 to 3 in the above picture. Then you will see a list of functions.

Insert Row

Get Row by Value

Get Multiple Rows

Update Row