Google Sheets Integrations as Trigger – Start Workflows from Spreadsheet Events

Google Sheet Integrations:  Use Google Sheets Integrations as Trigger in Bit Flow to launch automated workflows based on changes in your spreadsheets. When rows are added, updated, or deleted in Google Sheets, Bit Flow captures these events and triggers personalized actions—automatically and instantly.

Bit Flow is a super handy WordPress plugin that helps you connect your favourite tools and automate tasks—without needing to write any code. You can easily link up with over 317+ popular apps like Zoho CRM, Google Sheets, WooCommerce, Airtable, Trello, Dropbox, Zoom, HubSpot, Zoho Desk, and many more.

Instead of doing everything manually—like sending data from your forms to your CRM or updating spreadsheets—Bit Flow does it all for you automatically. It saves you time, reduces repetitive work, and keeps everything running smoothly.

In this guide, we’ll show you how to use Google Sheet as a starting point (called a trigger) to set up your first automation.

Setup Google Sheet Integrations

First, go to your Bit Flows Dashboard, click on Flows, and then either create a new flow or open an existing one.

After creating or opening an existing flow, you’ll be taken to the Flow Builder screen.

In the Flow Builder, you’ll see a section called Trigger. Under that, click on “Select an App.” A list of trigger apps will appear.

From the list, select your preferred trigger. For this example, click on “Google Sheet” You’ll then see all the available trigger events.

Now, select your preferred trigger event. For Example: “On Row Added“.

Now, select your “Poll Times ” click on add poll time then select Trigger Interval and Minutes Between Triggers.

After selecting your poll time, you’ll be asked to choose a webhook.

Here, you can either select an existing webhook if you’ve already created one, or create a new one by simply clicking the “Add Webhook” button.

Click on the “Add Connection” button to create a new connection. You will be required to enter your Client ID and Client Secret from your Google Console app. Additionally, you can set a connection name to easily identify it for future use. Remember, for the same Google account, you won’t need to connect again. Next time, simply select the connection from the drop-down list.

Get Client ID and Client Secret

To get your Client ID and Client Secret, you need to go to your Google Cloud Console and create an app.

1. Go to Google Cloud Console
   • Open the Google Cloud Console and sign in with your Google account.
2. Create a Project or Select an Existing Project
   • If you don’t already have a project, click on Create Project and follow the prompts to set it up.
   • If you have an existing project, select it from the project list.

3. Enable APIs:
   • Now, go to “APIs & Services.”
   • Search and enable both the Google Drive API and the Google Sheets API.

4. Configure Consent Screen:

• Go to “Configure Consent Screen.”
  • Click on “Get Started” under OAuth Overview.
  • Fill in App Information, Audience, Contact Information, and click Finish.
  • Click Create.
• Publish the App.
  • On the left menu, click Audience and Publish the app.
• Create a Client.
  • On the left menu, go to Clients and click “CREATE CLIENT.”
  • Select Web Application as the application type.
  • Enter a Name.
  • Add your Authorized JavaScript Origins and Authorized Redirect URIs (found on the integration page).
• Enable Data Access.
  • In the scope section, click on “Add or Remove Scopes.” Add these scopes. Then, click on “Update.”
    • https://www.googleapis.com/auth/drive
    • https://www.googleapis.com/auth/drive.file
    • https://www.googleapis.com/auth/drive.metadata
    • https://www.googleapis.com/auth/spreadsheets
    • https://www.googleapis.com/auth/userinfo.profile
    • https://www.googleapis.com/auth/userinfo.email
  • Scroll down and click Save.

5. Generate Client ID and Client Secret:
   • Go to the “Credentials” section.
   • Click on the download icon under the Action column.
   • A popup will appear displaying your Client ID and Client Secret.
   • Copy these credentials.
   • Paste them into the appropriate fields on the integration page.

•  now successfully established.

Congratulations! You have successfully connected your Google Console App with Bit Flows.

Once Bit Flows is successfully connected to your Google app, the newly created connection will automatically be selected under “Select Connection.”

After connecting with Google Sheets, you will need to select your spreadsheet. If you have multiple spreadsheets, choose the one you want to use for this action.

After selecting your spreadsheet, you will need to choose a specific sheet within it. Since a spreadsheet can contain multiple sheets, pick the one you want to use for this action. Here, we have two sheets available, and we will select the “Sheet2” sheet.

Once you’ve finished these settings, you can either click the “Test Run” button to check if the integration is working correctly or simply close the popup to complete the setup.