Hi everyone,
I am trying to automate a workflow where I retrieve data from a Google Sheet and update the spreadsheet after completing tasks on a website.
Currently, I am using the "Http Client" module in BAS, which communicates with a Google Apps Script (GAS) web app. However, this setup feels quite fragile. I have been struggling with several issues, such as:
Handling authentication and redirects (302) during HTTP requests.
Parsing JSON responses, which often fails due to unexpected HTML content being returned (e.g., getting a login page instead of the JSON data).
Frequent syntax errors when processing the returned data in BAS.
I want to know if there is a more reliable or "native" way to handle Google Sheets integration in BAS. Specifically, I am looking for:
Dedicated Modules or Extensions: Is there a built-in module or a community-made plugin specifically for Google Sheets API? I would prioritize this if it exists, as it would likely be much more stable than raw HTTP requests.
Best Practices: If I must use the "Http Client," are there any specific configurations to make the communication more robust against redirects and JSON parsing errors?
Any advice, recommended modules, or alternative workflows would be greatly appreciated. Thank you!
