Import spreadsheet data into Bubble
Make (formerly Integromat) checks in specified intervals whether there is a new row in a watched Google spreadsheet. If so, the data are imported to Bubble.
Greg Vonf
Software used in this automated workflow example
Bubble
Integromat
Make
Summary
Make (formerly Integromat) checks in specified intervals for new rows in a watched Google spreadsheet. If found, the data are imported to Bubble.
Detailed explanations
Step by step instructions
-
Create a scenario in Make (formerly Integromat).
-
Add the Watch a Spreadsheet module to the scenario.
-
Connect the module to your Google account and specify the URL of the spreadsheet you want to watch.
-
Set up the module.
-
Add the Bubble module to the scenario.
-
Connect the module to your Bubble account.
-
Select the operation Create/Update Record.
-
Enter the name of your Bubble application and the name of the Bubble Table into which you want to import the data.
-
Specify which columns in your Google spreadsheet correspond to which fields in Bubble.
-
Enable the option Import as new records only.
-
Set up the module.
-
Run the scenario and check the results in your Bubble application.
Business use case example
You want to track the number of visitors to your website in a Google spreadsheet and import the data into Bubble so that you can build a dashboard showing the number of visitors over time.