This topic was automatically generated from Slack. You can find the original thread here.
Hey all - I’m having some issues with the Google Sheets add_single_row action…
When adding a row to a spreadsheet, the action runs for the full length of time I allowed for the entire workflow, and then returns:
{"error":{"code":503,"message":"The service is currently unavailable.","status":"UNAVAILABLE"}}
Detailed traceback:
at Object.addRowsToSheet (file:///tmp/__pdg__/dist/code/eca719e975655cd6b9c7eada882a657bab39d5900d7d10be17cf34c9530d85f3/code/google_sheets/google_sheets.app.mjs:411:15)
at process.processTicksAndRejections (internal/process/task_queues.js:95:5)
at Object.run (file:///tmp/__pdg__/dist/code/eca719e975655cd6b9c7eada882a657bab39d5900d7d10be17cf34c9530d85f3/code/google_sheets/actions/add-single-row/add-single-row.mjs:105:18)
at global.executeComponent (/var/task/launch_worker.js:139:22)
at MessagePort.messageHandler (/var/task/launch_worker.js:598:28)
The only other unique item I can think of is that the sheet I’m trying to add to is quite large (~78k rows). Is there any limit that the Google API places on the size of the sheet you can use this action with? Open to any feedback y’all have. Thanks!