Import new records into Betty Blocks from a Google Sheets spreadsheet
About
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
Apps Included
Similar templates for inspiration
Looking to get more out of your apps? With Make, you can visually integrate any app into any workflow to save time and resources - no coding required. Try any of these templates in just a few clicks.
Create your own workflow
Create custom workflows by choosing triggers, actions, and searches. A trigger is an event that launches the workflow, an action is the event.
Creates a new conditional format rule at the given index. All subsequent rules' indexes are incremented.
Appends a new row to the bottom of the table.
Adds a new sheet.
Clears a specified range of values from a spreadsheet.
Cleares a specific cell.
Clears values from a specific row.
Copies a sheet to another spreadsheet.
Creates a record of a specified data model.
Creates a new spreadsheet.
FAQ