![]() If you don't already have a way to get one, that's probably a good topic for a separate SO question in any case. I used CURL to make sure that it behaved as a REST api, but the technique I used to get an OAuth token there is both a distraction and frankly a little scary to include here since it's really easy to mess up. ![]() The tricky part (as usual) is getting the OAuth token or API key set up, but if you're already calling the Google Sheets V4 API, you've probably already got that dialed in. You can deploy it and test it out easily in the browser just by visiting the "Current web app URL" (as provided when you publish as web app from the script editor), and accepting the consent screen, or even just visit the one that I deployed (configured to execute as the accessing user, and unverified/scary consent) at the example URL. It takes a Google Sheets spreadsheet id and sheet name (and optional download filename) as query parameters, and returns the corresponding theoretically RFC 4180 compliant CSV file.įurther instructions on deploying an Apps Script project as a web app are here. If you don't have easy access to or familiarity with PHP, here's a very barebones Google Apps Script Web App that once deployed and the caller permission accepted, should allow clients with an appropriately scoped access token or api key to export an existing Google Sheet to a csv file. With example that generate output having CSV structure. There is now great documentation on address: ![]() #Delete all lines beginning with a # from a file I use this second script to process it #!/bin/bash The problem you will probably have is connected with strange spaces in obtained file. If you use only one card in document, their number is: g_id="0" G_id="number_assigned_to_card_in_google_sheet" From this url you should extract long id composed from big and small letters and numbers. ![]() ![]() Firstly you should make document accessible for anyone. ![]()
0 Comments
Leave a Reply. |