Modify a google apps script to automatically load (& nightly refresh) data into a google sheet
Budget: $10 – $30 USD
Request details
This has been done using this script:
https://github.com/tk-sheldo/JSON-to-sheet/blob/main/main-file
This is the api url call I need to make in the script (ln 32):
https://api.inaturalist.org/v1/observations?taxon_id=47521&nelat=47.851637&nelng=-122.057324&swlat=47.435164&swlng=-122.446920&order=desc&order_by=created_at
I need to setup a new google table and have it run this script (with the url changes) nightly.
Deliverables
refreshing google table with script
script with url setup
This has been done using this script:
https://github.com/tk-sheldo/JSON-to-sheet/blob/main/main-file
This is the api url call I need to make in the script (ln 32):
https://api.inaturalist.org/v1/observations?taxon_id=47521&nelat=47.851637&nelng=-122.057324&swlat=47.435164&swlng=-122.446920&order=desc&order_by=created_at
I need to setup a new google table and have it run this script (with the url changes) nightly.
Deliverables
refreshing google table with script
script with url setup
Related categories:
Google Sheets