Import new records into Betty Blocks from a Google Sheets spreadsheet
Periodically check for new rows in Google Sheets and import them as new records into a Data model in Betty Blocks. The template works with this sample Google Sheet (a fruit inventory) [here](https://docs.google.com/spreadsheets/d/1iJ9BMxilUemqOkv-dNl2dWzAosPGS3haGV0T-Q7k6jc/edit#gid=1582596100). The template also expects a "Data model" in Betty Blocks with these properties: 1) Fruit Name as text 2) Price as number with decimal 3) Quality as list (High, Medium, Low) 4) Sold Since as date
Periodically check for new rows in Google Sheets and import them as new records into a Data model in Betty Blocks.
The template works with this sample Google Sheet (a fruit inventory) here.
The template also expects a "Data model" in Betty Blocks with these properties:
- Fruit Name as text
- Price as number with decimal
- Quality as list (High, Medium, Low)
- Sold Since as date
New buyers can create an account from the cart to unlock a controlled $10 first-purchase credit on eligible orders of $25+.
Secure checkout powered by Stripe
Support
How to import this workflow into Make
- 1Purchase or download the workflow to get the Make blueprint JSON file.
- 2In Make, create a new scenario, click the three-dots menu, and choose "Import Blueprint".
- 3Reconnect each module to your own app connections when prompted.
- 4Run the scenario once to verify it, then set your schedule and turn it on.
Related App Development workflows
- Create a data thing on Bubble using data from a Google Sheets spreadsheetFree
- Create records in Betty Blocks based on events in Google Calendar$4.99
- Import spreadsheet data into BubbleFree
- Send data to Make as JSON via an action in a Bubble workflow using the API Connector plugin$3.99
- Send data via HTTP when an iOS button is pressed$2.99
- Update records in Adalo from a list of existing records$2.99
More from Jonas Sato
Need this deployed? We'll set it up for you.
Our automation experts deploy this workflow in your stack, connect your accounts, and verify it works — or build a custom solution from scratch.