Hi all,
Is there any way to read from a Google sheet, other than manually copy pasting the data from the web URL, (which is not altogether bad for me, except users would struggle with the concept and interfere).
Ideally I would like to do this in the background silently. (Well, with a message saying updating data).
I did search but can not find anything.
Thank you.
Reading from a Google Sheet
Moderators: Dorian (MJT support), JRL
- Phil Pendlebury
- Automation Wizard
- Posts: 538
- Joined: Tue Jan 16, 2007 9:00 am
- Contact:
Reading from a Google Sheet
Phil Pendlebury - Linktree
- Phil Pendlebury
- Automation Wizard
- Posts: 538
- Joined: Tue Jan 16, 2007 9:00 am
- Contact:
Re: Reading from a Google Sheet
btw. I should add here that HTTP Request works on a shared public sheet but the data is impossible to parse. It is just crazily complex and not regularly formatted.
Phil Pendlebury - Linktree
- Dorian (MJT support)
- Automation Wizard
- Posts: 1358
- Joined: Sun Nov 03, 2002 3:19 am
- Contact:
Re: Reading from a Google Sheet
There isn't another way that I'm aware of. We always try to steer people towards Excel as of course we have those native Excel commands. But I realize this isn't much help.
Yes, we have a Custom Scripting Service. Message me or go here
- Phil Pendlebury
- Automation Wizard
- Posts: 538
- Joined: Tue Jan 16, 2007 9:00 am
- Contact:
Re: Reading from a Google Sheet
Thanks Dorian, yes I found that pasting a text file to Githib and reading it RAW works really well.
Phil Pendlebury - Linktree