Import new records into Betty Blocks from a Google Sheets spreadsheet
Apps used in template
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
Trusted by thousands of fast-scaling organizations around the globe
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.
The Google Sheets module checks for matches between the sender’s email address and the list of client email addresses. If a match is found, the label client_mailbox
is added to the email. More information here.
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
How Make works
Thousands of fast-scaling businesses create and automate on Make