Import new records into Betty Blocks from a Google Sheets spreadsheet
Import new records into Betty Blocks from a Google Sheets spreadsheet
Get this template
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
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.
Appends multiple rows to the bottom of the table.
Updates multiple rows.
Clears a specified range of values from a spreadsheet.
Clears a specific cell.
Clears values from a specific row.
Copies a sheet to another spreadsheet.
FAQ
See Make in action
See how Make works
Trusted by 200,000+ customers
"Make really helped us to scale our operations, take the friction out of our processes, reduce costs, and relieved our support team. It is difficult to not become a fan."
"Make drives unprecedented efficiency within our business in ways we never imagined. It’s having an extra employee (or 10) for a fraction of the cost."
"The simplicity, flexibility and ability to build real complex automations without any knowledge of programming makes it the best thing since sliced bread."
"True citizen development in the entire company. Make is present in every department, empowering the company to offer a unique customer experience."