Automatically add a new row to Google Sheets when you receive a new Google Business review
Start today
Other popular Google Sheets workflows and automations
-
3 - Track watering in a Google spreadsheet
2.1k - Call Log, Missed call 3.8k
- Put all your completed tasks in a Google Spreadsheet
5.7k - Save all of your liked videos in a spreadsheet14.8k
- Keep track of a particular stock's daily closing price in a spreadsheet2.0k
- Back up new texts you receive on your Android device to a Google Spreadsheet 13.2k
- Log every time you stop charging your phone to a Google spreadsheet 2.8k
- Keep a log of your recently played tracks
1.0k
Useful Google Sheets and OneDrive integrations
Triggers (If this)
New file in folderThis Trigger fires every time a new file is created in the folder you specify.- New spreadsheet added to folderThis trigger fires when a new spreadsheet is added to a Google Drive folder you specify. Note: only works for spreadsheets created after the Applet turned on.
- New photo in folderThis Trigger fires every time a new photo is created in the folder you specify.
- New worksheet in spreadsheetThis trigger fires when a new worksheet is added to a spreadsheet you specify.
- New tagged photo in folderThis Trigger fires every time a new photo with the tag you specify is created in the folder you specify.
- New row added to spreadsheetThis trigger fires when a new row is added to a spreadsheet you specify.
- New file matching regex in folderThis trigger fires every time a new file whose filename matches the regular expression you specify is added to the folder you specify
- Cell updated in spreadsheetThis trigger fires when a particular cell is updated within the spreadsheet you specify.
- New file matching search in folderThis trigger fires every time a new file whose filename or file contents contains the words you specify is added to the folder you specify
- New file or folder shared with meThis trigger fires every time a new file or folder is shared with you
Queries (With)
- History of files uploaded in folderThis query returns a list of recent files created in the folder you specify.
- Current values of a rowThis query returns the current values in a given row. Values from columns A-Z are available as ingredients.
- History of file matching search uploaded in folderThis query returns a list of recent files whose filename or file contents contains the words you specify is added to the folder you specify
- Current value of a cellThis query returns the current value of a single cell in your spreadsheet.
- History of files or folders shared with meThis query returns a list of recent files or folders shared with you
- History of rows added to spreadsheetThis query returns a list of when a new row is added to a spreadsheet you specify.
- History of photo uploaded in folderThis query returns a list of recent photos created in the folder you specify.
- History of when Cell was updated in spreadsheetThis query returns a list of when a particular cell was updated within the spreadsheet you specify.
- History of photos with a tag uploaded in folderThis query returns a list recent photos with the tag you specify is created in the folder you specify.
- History of spreadsheets added to folderThis query returns a list of when a new spreadsheet is added to a Google Drive folder you specify. Note: only works for spreadsheets created after the Applet turned on.
- History of file matching regex uploaded in folderThis query returns a list recent files whose filename matches the regular expression you specify is added to the folder you specify
- History of worksheets in spreadsheetThis query returns a list of when a new worksheet is added to a spreadsheet you specify.
Actions (Then that)
- Create text fileThis action will create a new text file at the path you specify
- Add row to spreadsheetThis action will add a single row to the bottom of the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created after 2000 rows.
- Append to a text fileThis Action will append to a text file as defined by the file name and folder path you specify
- Update cell in spreadsheetThis action will update a single cell in the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created if the file doesn't exist.
- Add file from URLThis Action will download a file at a given URL and add it to OneDrive at the path you specify. NOTE: 30 MB file size limit.
Google Sheets and OneDrive resources
How to export Google Contacts
Click to learn how to export Google Contacts - Automate your Gopogle Contacts
5 best cloud storage apps to access docs easily
Find the best cloud storage apps for accessing your content easily and learn how IFTTT can help you integrate your cloud storage with other tools you love.
IFTTT helps all your apps and devices work better together