Google Sheets Integrations with Bit Flows – Automate Data Syncs

Google Sheet Integrations: Create online spreadsheets with Google Sheets. Collaborate in real-time from any device and leverage AI to generate formatting, analysis, and more.

In this guide, you’ll learn how to integrate Bit Form with Encharge, where Bit Form serves as the trigger and Encharge is the action. Once the integration is complete, a new subscriber will be automatically added to your Encharge list whenever someone submits your form.

This easy, step-by-step tutorial is perfect for beginners and will help you quickly set up your first automation—empowering you to grow your email list, simplify communication, and manage contacts directly from your WordPress site.

Authorization of Google Sheet Integrations as Action

To add an action, click on the plus (+) icon located next to your trigger. This will add a new step to your workflow.

Select an App

After adding your Action Step, you need to select an app to send your data. To select an app, click on the plus (+) icon in the Action Step. This will open a popup displaying a list of all available apps.

From the app list, you can choose your preferred action. You can also search for the app where you want to send your data. For this example, we will choose Google Sheets as the action.

Select App Action Event

If you select Google Sheets for the action, as we did, you will see the available events that can be performed. For example, when you click on Google Sheets, the available event is “Add Row.” This means that whenever the trigger event runs, a row of your data will be added to Google Sheets.

Add Connection

After choosing the “Add Row” event, you will be prompted to select a connection. Click on the “Add” 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 “arouf.towpSite” sheet.

After choosing your sheet, you need to map the trigger fields with the action fields, which in this case is Google Sheets. To map your fields, click on the Add Row button. You will then see two fields: Column and Value.

• For Column, select the column from your chosen spreadsheet.
• For Value, map it to the corresponding trigger response field, which in this case is WordPress On Post Status Update event. Additionally, you can use options like Flow, Math, String, or System for custom values or calculations.

For more guidance, follow the demo video below.

Congratulations! You have successfully set up Google Sheets as your action.

After setting up the trigger and actions, you can test your flow to verify if the integration is working correctly. To do this, simply click on Test Flow Once. Then, complete the trigger event, which in this case is WordPress On Post Status Update. For demonstration, let’s change the status of a post and observe the results.

Integration Log

You can check your integration logs to monitor the flow’s activity. To view the logs, click on the Logs button located at the top-right corner. All the logs related to this flow will be displayed there.