How do I grab cell data out of google sheets?

PoppaWoody · November 14, 2022, 5:06pm

I need to grab stock data out of a google sheet daily after market close and store. I can write code in any language, but I have no idea where to start for something like this on an iPhone or an iPad. I don’t think short cuts would cut it, but I may be wrong. I believe my first and biggest hurdle is how to grab data from a cell in a google sheets doc that is automated and gives me end of day gains and losses. Since is a single sheet/template it gets updated every day with that days market data, so I need to capture that data at the end of day before it is over written the next morning when the markets open.
What scripting tool should I use?
Thanks in advance

sylumer · November 14, 2022, 5:30pm

You could do something with Shortcuts using ShortSheets.

But, I would also recommend you look at Google Apps Script as that likely gives you a lot of additional scope and power independent of your mobile device.

Hope that helps.

supermamon · November 14, 2022, 10:40pm

I used Google Apps Script for this before. See if this helps.

gist.github.com

https://gist.github.com/supermamon/5080a599f3719541cb48b3c3ab4e1502

code.js

/*
How to setup
============

1. Go to https://script.google.com and login
2. Click New Project
3. Give the project a name be clicking on "Untitled Project" and giving a new name
4. Copy this whole code and overwrite everything on Code.gs file. Click on the Save icon to save.
5. Go to Google drive and open the worksheet that you want to manipulate
6. Take a look at the url. It should be in this format -- https://docs.google.com/spreadsheets/d/spreadheet-id-as-some-long-seemingly-random-characters/edit#gid=478439860

This file has been truncated. show original

oldblueday · November 15, 2022, 12:42am

I’ve used Google Apps Script (basically javascript control of all of Google’s products) and looks like they have a REST API implementation (which I haven’t used). That might work.