With Albato, you can automate your workflows in Google Sheets. You can create and update rows, track changes to sheets, and more. Set up triggers to automatically respond to new rows or updates, and use actions to manage your data.
How to Connect Google Sheets to Albato?
General instructions: https://albato.com/blog/publications/connecting-google-sheets-to-albato
If you want to use the "Watch for cell change and send the row" trigger (webhook trigger that receives data in real time), then you'll need to install the Albato extension. For more details on setting it up, check out the article and video.
Webhook trigger installation Instructions: https://albato.com/blog/publications/new-google-sheets-trigger
General Questions
Why isn't data coming into Google Sheets?
Data may not be coming in because the table rules are not followed. For example, if hidden columns are being added and cells are being merged, this could cause problems. Learn the rules for correct operation in the article.
Don't use filters on columns.
Don't use formulas in columns where data is passed.
Don't hide rows or columns.
Don't rename or add sheets without updating the data in the connection.
Sheet names must be letters and/or numbers.
What permissions do I need to integrate with Google Sheets?
Make sure you have the right permissions to edit the table and check that there aren't any Excel spreadsheets in your shared list.
What are the main features and limitations of integrating Google Sheets?
The integration only supports Google Sheets. If you need to work with Excel spreadsheets, you can use the Microsoft Excel app.
How do I catch rows added to a table from Google Forms?
Use the "Watch for cell change and send the row" trigger to set up such an integration.
Errors
How Albato handles errors can be found in the article: Error Handling
Google Sheets error: "Quota exceeded for quota metric 'Write requests' and limit 'Write requests per minute per user'."
Albato will send a resubmit request after 5 minutes, then after 15 minutes, and so on, following the rules for handling resubmit errors. If the problem persists, contact our support via the online chat on the site.
Error in the Google Sheets automation log: "Exceeds grid limits".
This error appears if the table has run out of empty rows or missing columns (deleted). Check the table for free rows and columns. If the problem persists, contact our support via the online chat on the site.
Error when transferring a phone number:
An invalid phone number format or mask is used. The table recognizes the phone number as a formula. To solve the problem, when sending the number in the format +1 (900) 000-00-00, put an apostrophe (') before the phone number. The table will then accept the data correctly.
It is forbidden by Google Sheet's API to use a colon (:) in the sheet name.
Specific Issues and Instructions
How can I change the decimal points in prices from dots to commas, or vice versa?
Open File → Table Settings → Regional Settings → Select the desired region (e.g. USA) → Save Settings.