Save my spreadsheet data creating a new GCS csv file
475 views
Skip to first unread message
lolilol44400 lol
Mar 28, 2022, 12:13:14 PM3/28/22
to Google Apps Script Community
I have a shared google spreadsheet shared with company users.
1) It is a template where they fill data and backup in their own drive as a csv file.(app script function set on a button in the spreadsheet)
2) After, they take the created file and upload it manually on a GCS bucket.
Later on, a scheduled job ingest this file into big query. I can't directly write it into big query as the cloud composer job have many rules to check if the data have a correct format before ingestion.
**TODO:**
To make the process simpler, i would like the user do step 2 automaticaly. when one user clic on a button it push the spreadsheet data directly in a new file in GCS storage .(app script function set on a button in the spreadsheet)
I don't know if it is even possible to do this. If it is possible, how i should do this ?
1) It is a template where they fill data and backup in their own drive as a csv file.(app script function set on a button in the spreadsheet)
2) After, they take the created file and upload it manually on a GCS bucket.
Later on, a scheduled job ingest this file into big query. I can't directly write it into big query as the cloud composer job have many rules to check if the data have a correct format before ingestion.
**TODO:**
To make the process simpler, i would like the user do step 2 automaticaly. when one user clic on a button it push the spreadsheet data directly in a new file in GCS storage .(app script function set on a button in the spreadsheet)
I don't know if it is even possible to do this. If it is possible, how i should do this ?
Stephen Barker
Mar 29, 2022, 11:11:21 AM3/29/22
to Google Apps Script Community
It looks like you can but your button click will have to create the .csv/json then upload it.
Reply all
Reply to author
Forward
0 new messages