How to sync data from Coda to Google Sheets and Google Sheets to Coda using Google Apps Script

Thank you again, @Al_Chen_Coda!

I realized my problem was that I’d copied a View ID instead of the source Table ID.

However, I’ve now run into a different error because it looks like our table is too big!

Exception: Request failed for https://coda.io returned code 422. Truncated server response: {“statusCode”:422,“statusMessage”:“Unprocessable Entity”,“message”:"Sorry, this doc has 155% of the maximum content size to be accessible via the C… (use muteHttpExceptions option to examine full response) (line 267, file “Coda”)

We’re only 55% over the limit — is there any chance this will be expanded in the future? Or perhaps a way to extract a filtered section of the data (a view, for example) for use with the script?

1 Like