I also tried modifying the URL, since it appears to me that the URL string is intended for an 'upload' (ie. Or, were you referring to something else, for me to perhaps include in the 'header' line of code, as in - were you referring to this section? Should I try to make a change to this:Īuthorization: 'Bearer ' + service.getAccessToken(), Please advise: what are you referring to when you say 'don't forget to include in the header the bearer from apps script' - is that what you explained further in the appsscript.json file? If so, then I have already tested it by including the right scopes added to the script - so I wouldn't think that is the source of the issue here in this code example. However, after I keyed in the appropriate params at the top of the code, and changed the METHOD to GET (instead of POST), it resulted in an error. I tried implementing the code per the article of your link.

As a result, I tried implementing the sample code provided in the above article for testing purposes. The coder/author of the article mentions at the end that this is a good way to keep the data process internal, and going through OAuth keeps it even out of the service account (again, better security protocols/best practice). Since I'm relatively new to the Google Cloud space, with basic but limited understanding of Apps Script JSON-based coding knowledge/skill, I found this article (dated in 2021) which has the custom code instructions detailed already: My preference is to complete this daily automated task with the csv file marked as private, for security purposes, and if possible, to use OAuth to complete the internal retrieval of the csv data and to parse it to a spreadsheet - with the csv file to be updated with new data on a recurring basis. via Trigger) a csv that I have stored in my Google Cloud Storage bucket. My goal is to write a custom code script for a Google Sheet in Apps Script that auto-retrieves (ie.

Csv file to google sheets