Are there any limitations for the Google Sheets integration?
The intended use-case for our Google Sheets integration is the following: You receive e-mails containing one or a few data sets. The parsed data gets then copied to Google Sheets and creates a couple of new rows in your spreadsheet. If you have this scenario, the Google Sheets integration will work perfectly fine for you and you should not expect any issues.
Another use-case which we see from time to time is the following: users parse CSV or Excel file attachments and want to transfer hundreds of data rows to a Google Sheet for each e-mail. This means that we need to send hundreds of requests to the Google Sheets API for each e-mails.
This use-case is possible in theory, there are however limitations in place at the moment. The maximum number of webhooks per e-mail is set to 2000. Which means that you can not have more than 2000 rows per e-mail.
Furthermore, the maximum number of rows a Google Spreadsheet can hold is 2 000 000. In case you are handling hundreds of rows per e-mail, your Google Spreadsheet will fill up quite fast.
Note: We are working on a new version of the Google Sheets integration which supports batch processing. By using batch processing, the integration will work more reliable for e-mails with multiple rows of parsed data.