From Google Sheets to ThingSpeak | General | Forum

Avatar

Please consider registering
Guest

sp_LogInOut Log In sp_Registration Register

9   +   10   =  

Register | Lost password?
Advanced Search

— Forum Scope —






— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_Feed sp_TopicIcon
From Google Sheets to ThingSpeak
No permission to create posts
June 25, 2020
7:06 pm
Avatar
vinnymoy
Madrid
New Member
Members
Forum Posts: 1
Member Since:
June 25, 2020
sp_UserOfflineSmall Offline

Hi everybody!

This is the problem. I have a Tilt Hydrometer (https://tilthydrometer.com). The Tilt send the data to a Google Sheet. Then, I need to take that data and put it in a ThingSpeak channel. I'm a beginner in ThingSpeak, And I really need the help with this. Any idea?

June 26, 2020
10:59 am
Avatar
doutlook

Silver
Members
Forum Posts: 7
Member Since:
June 10, 2019
sp_UserOfflineSmall Offline

This looked like an interesting challenge so I spend a few minutes looking into it.

I would start by making a copy of their spreadsheet and accompanying script https://tilthydrometer.com/blogs/news/easiest-way-yet-to-post-your-tilt-to-google-sheets.

Next look at the script code in the Google sheet and find the place where it inserts the data into a new row. Using the Google fetch() function https://developers.google.com/apps-script/reference/url-fetch/url-fetch-app#fetch(String,Object) you could post the data to the Thingspeak API.

Forum Timezone: America/New_York

Most Users Ever Online: 166

Currently Online:
29 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

rw950431: 272

Vinod: 240

piajola: 95

turgo: 70

vespapierre: 63

Adarsh_Murthy: 62

Member Stats:

Guest Posters: 1

Members: 8665

Moderators: 1

Admins: 2

Forum Stats:

Groups: 3

Forums: 14

Topics: 1600

Posts: 5760

Newest Members:

briskpanda, Dejw0089, Yassine Ben Salah, anis, 43994554AKS, suda

Moderators: cstapels: 460

Administrators: Hans: 405, lee: 457