Are you stressing yourself to find a way to connect Google Sheets to Bubble apps automatically? If yes, then in this blog we will guide you to a step by step procedure to easily transfer data from Google Sheets to Bubble for free.

Connect Google Sheets to Bubble Apps

Pabbly Connect is an amazing integration and automation software, which allows you to integrate two or more applications to automate all the projects. You just have to do the integration once and then everything will be automatically managed by Pabbly Connect.

Why Choose This Method Of Integration?

In contrast with other integration services-

  • Pabbly Connect does not charge you for its in-built apps like filters, Iterator, Router, Data transformer, and more
  • Create “Unlimited Workflows” and smoothly define multiple tasks for each action
  • As compared to other services which offer 750 tasks at $24.99, Pabbly Connect offers 50000 tasks in the starter plan of $29 itself
  • Unlike Zapier, there’s no restriction on features. Get access to advanced features even in the basic plan
  • Try before you buy! Before spending your money, you can actually signup & try out the working of Pabbly Connect for FREE

Sign Up To Pabbly Connect

Before we bounce straight into the integration process, let us get a smidgen of information about both services. Well, Google Sheets is a free web-based tool that allows users to create and format spreadsheets while collaborating with other users in real-time. Whereas, Bubble is a no-code app building platform, designed to help you build software and applications without programming.

Although, there is some kind of native integration between Google Sheets and Bubble but that is limited. Hence, we will be going to use Pabbly Connect to integrate Google Sheets and Bubble.

By integrating Google Sheets and Bubble, whenever a new row is added in Google Sheets subsequently creates a data thing in Bubble. Additionally, we have attached a video tutorial of this integration so that you can use the workflow more effectively.

Moreover, you will be able to try out the workflow of this integration for free as well, simply hit the ‘Use Workflow’ button to start with a ready-made template. Plus, you can visit Marketplace to discover more integrations and workflows.

Connect Google Sheets to Bubble Apps Workflow

Now, let’s dig into the step-by-step procedure to integrate Google Sheets and Bubble automatically.

Step 1: Sign up to Pabbly Connect

Sign Up

Kick-off the process to connect Google Sheets to Bubble apps by clicking on the ‘Sign Up Free’ icon on the Pabbly Connect dashboard. Subsequently, either fill-up the details manually or sign up using Gmail credentials.

Try Pabbly Connect for FREE

Step 2: Access Pabbly Connect

Select Connect

After signing up successfully, click the ‘Access Now’ button of the software ‘Connect’ within Pabbly application.

Step 3: Workflow for Google Sheets with Bubble Integration

(a) Start with a New Workflow

Create New Workflow

Start with creating a workflow to connect Google Sheets to Bubble apps by striking the ‘Create Workflow’ button.

(b) Name the Workflow

Google Sheets to Bubble.io Integration

Continue the process by naming the workflow according to the use case. For this integration, we named the workflow ‘Google Sheets to Bubble’. Finally, press the ‘Create’ button.

Step 4: Setting Triggers for Google Sheets to Bubble Integration

After naming your workflow, you have to select the application you want to integrate. Sign up for a free account now to integrate thousands of apps.

(a) Select Application you want to Integrate

Select Google Sheets for Google Sheets to Bubble Integration

In this case, we are choosing ‘Google Sheets’ for integration and select ‘New Spreadsheet Row’ in the choose method section.

(b) Copy the Webhook URL

Copy Webhook URL

After selecting the application, now you have to copy the webhook URL just like in the above-shown image to take further the integration process.

Step 5: Connecting Google Sheets to Pabbly Connect

To connect with Google Sheets, you have to paste the copied Webhook URL in your Google Sheets add-ons section.

(a) Capture Webhook Response

Capture Webhook Response for Google Sheets to Bubble Integration

Promptly, first you have to click on the ‘Capture Webhook Response’ button to capture the data from Google Sheets.

(b) Add Data to Google Sheets

Add Data to Google Sheets

Next, go to your Google Sheets and start adding the data in row that you want to transfer to Bubble.

(c) Click on Add-ons

Click on Add-ons

After adding the data in row, click on the ‘Add-ons’ menu, and then click on the ‘Get add-ons’ button. Promptly, ‘Google Workspace Marketplace’ will open up.

(d) Install Pabbly Connect Webhook

Install Pabbly Connect Webhook

Here search for ‘Pabbly Connect Webhook’ from the search bar and then simply click on ‘Install’ button to install the add-on to your Google Sheets.

(e) Go to Initial Setup

Go to Initial Setup

As soon as you install the add-on, refresh the tab. After that, click on ‘Add-ons’ menu and ‘Pabbly Connect Webhook’ will appear there. Simply, click on it and then select ‘Initial Setup’ to paste the Webhook URL.

(f) Paste the Webhook URL

Paste Webhook URL

Subsequently, a window will pop-up, here paste the Webhook URL and mention the last data entry column in ‘Trigger Column’ field. In the end, hit the ‘Send Test’ button and then click on ‘Submit’ button.

(g) Click on Send On Event

Click Send on Event

This is an additional step, to ensure that every time a new data is added to the sheet then it will automatically trigger the webhook. For this, you have to again go to ‘Pabbly Connect Webhook’ section from ‘Add-ons’ menu and then click on ‘Send on Event’ tab.

Step 6: Test the Response in Pabbly Connect Dashboard

Test the Response for Google Sheets to Bubble Integration

Forthwith, as you click on the ‘Send Test’ in Google Sheet, the entry will appear on the Pabbly Connect dashboard. Then, click on the ‘Save’ button.

Step 7: Setting Action for Google Sheets to Bubble Integration

In this step, we will be adding an action for our trigger to complete the integration process.

(a) Select Application you want to Integrate

Select Bubble for Google Sheets to Bubble Integration

Now, click on the + button below and choose ‘Bubble’ and in the method section select ‘Create a Thing’.

(b) Click on Connect Button

Connect with Bubble for Google Sheets to Bubble Integration

After choosing the application click on the ‘Connect with Bubble’ button to move forward.

Step 8: Connecting Bubble to Pabbly Connect

To connect Bubble with Pabbly Connect, you need to paste the Token and enter Application Name in the software. For that, you need to log into your Bubble account.

(a) Select an App

Select an App for Google Sheets to Bubble Integration

Once you logging to your Bubble account, you will see all your apps in the dashboard. Select any one of them.

(b) Go to Settings

Go to Settings

Next, from the left sidebar click on the ‘Settings’ option and then click on ‘API’ section.

(c) Generate New API Token

Generate New API Token

In the API section, tick mark all the checkboxes under ‘Public API endpoints’ and also click on the ‘Generate a new API Token’ button.

(d) Copy the API Token

Copy API Token Bubble

After that, a new ‘API Token’ has been generated. Assign a name to it and copy the ‘Private Key’.

(e) Paste the API Token

Paste API Token for Google Sheets to Bubble Integration

Subsequently, paste the copied private key in ‘API Token’ section in Pabbly Connect window and also add ‘Application Name’ from ‘Workflow API root URL’ section. At last, click on the ‘Save’ button.

(f) Map the Fields

Map the Fields for Google Sheets to Bubble Integration

Now, you have to map the data to their respective fields such as data type, field name and field value.

(g) Save and Send Test Request

Save and Send Test Request

Once you are done mapping all the field data, click on ‘Save and Send Test Request’ button.

(h) Check and Save Response

Check and Save Response

Promptly, you will get the API response and the integration of Google Sheets and Bubble is successfully set-up.

Step 9: Check Response in Bubble Dashboard

Check Response in Bubble for Google Sheets to Bubble Integration

Eventually, when you check your Bubble dashboard a new data thing has been created from the Google Sheets row.

Conclusion –

Hence, now you know the entire approach on ‘How to Connect Google Sheets to Bubble Apps’ using Pabbly Connect. All you have to do is follow the above-mentioned steps & you can easily integrate Google Sheets to Bubble.

With the help of Pabbly Connect, you can easily connect unlimited premium apps. So, don’t wait anymore. Go and get your access by signing up for a free account.

In case of any doubts or suggestions, please drop your comments below.

You May Also Like to Read: