How to integrate Google Sheets with Bubble to automatically reflect data in Bubble when a row is added

[What is Yoom]

The steps for this integration flow are broadly as follows:

・Integrate Google Sheets and Bubble with My Apps
・Copy the template
・Set triggers and actions
・Finally, confirm the trigger activation

Pre-configuration

1) First, please access the official Yoom website and create an account.
Yoom Account Issuance Page
2) An access token is required for Bubble app registration.
Log in to Bubble in advance, go to "Settings > API", and obtain the API Token.
The subdomain can be confirmed from the app's URL. For example, if the URL is "https://yoom.bubbleapps.io", "yoom" is the subdomain.
Also, in Bubble, go to "Settings > API" and enable the API by checking Workflow API and Data API, and the Data Type to access under "Public API endpoints".

How to Create a Google Sheets and Bubble Integration Flow

Step 1: Integrate Google Sheets and Bubble with My Apps

1) Once logged into your Yoom account, register the app you will use.
Click "My Apps" and select "New Connection".

2) A list of apps that can be connected with Yoom will be displayed. Use the search bar at the top to search for the two apps you will use this time, "Google Sheets" and "Bubble", one by one.

Once you can select Google Sheets, log in with your Google account.

For Bubble, enter the account name and the access token obtained during the pre-configuration, and click "Add".

‍

3) Once registered, an icon will be displayed in My Apps.
Check if the icon of the registered app is displayed.

Step 2: Copy the Template

Click this banner.

1) Click on the "Try this template" icon.

2) A display like the following will appear, click "OK".

If it is displayed as follows, the copy is complete.

The title and details can be edited by clicking, so please change them as needed.
Click the icons with "!" displayed on the right in order from the top to set the operation.
Note that this template is saved in My Projects.
Therefore, the copied template can also be opened from My Projects.

Step 3: Set the Trigger

‍Click "App Trigger When a row is updated".

Step 4: Set Google Sheets Action

1) Select the action "When a row is added" and click "Next".

‍
2)  Enter the required fields.
The trigger activation interval varies depending on the subscription plan.
For details on each plan, please refer to this.
List of feature restrictions and usage limits for each plan | Yoom Help Center (intercom.help)

The spreadsheet ID can be selected from the candidates if the app is linked.

Once the input is complete, click "Test" and after a successful test, click "Save".

Step 5: Set Bubble Action

1) Return to the flow and click the "Create Thing with App" icon.

2) Select the action "Create Thing" and click "Next".

3) Enter the required fields.

If the app is linked, you can use the output information from Google Sheets to input.

Select from the candidates as needed for values, and once input is complete, click "Save".

This completes the flow of "Add a record to Bubble when a row is added in Google Sheets".

‍

Step 6: Test and Verify

Once the setup is complete, a display like the following will appear, click "Turn on Trigger".
Start the flow bot and verify it operates correctly.

‍

The template used this time is here

Other Automation Examples Using Bubble

Here are some other automation templates using Bubble available in Yoom.

Please utilize these templates according to the tasks you want to automate or in combination with the apps you are currently using.

1. Create a folder in Google Drive when a Thing is created in Bubble
This template automatically creates a dedicated folder in Google Drive when a new Thing is created in Bubble.
For example, when a project management team creates a new Thing, a folder for organizing related materials and files is automatically generated in Google Drive, allowing the entire team to access it immediately.
This eliminates the need for manual file management, improving work efficiency and reducing the effort required for file organization.

2. Notify via Gmail when a Thing is created in Bubble
This template allows you to automatically send email notifications via Gmail when a new Thing is created.
For example, when the sales department creates a Thing in Bubble, the sales representatives quickly receive an email, helping to prevent missing important information.
This eliminates the need for manual notifications and enables speedy information sharing, which is expected to improve the speed and efficiency of sales activities.

3. Add Information Registered in Bubble to Notion
This template allows you to automatically add information registered in Bubble to Notion.
For example, when the marketing department enters new customer data into Bubble, related information is automatically added to Notion, allowing the entire team to quickly access it.
This eliminates the need for manual data transfer, improving the efficiency of information sharing and preventing errors.

Summary

In this blog, we explained how to integrate Google Sheets with Bubble to automatically record information when a new row is added.
This integration eliminates the need for manual input and enables quick data synchronization, which can improve data management efficiency and speed up information sharing.
Moreover, such automation not only enhances work efficiency but also helps prevent task omissions and ensures reliable information management. By optimizing data integration, you can reduce daily work stress and improve productivity.
Additionally, by utilizing the no-code tool Yoom, you can streamline tasks without programming knowledge.
It is easy to set up even for beginners, so consider implementing it on this occasion.