From Google Sheets to ThingSpeak

13 views (last 30 days)
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?

Accepted Answer

Vinod
Vinod on 26 Jun 2020
You can set up a MATLAB analysis code to use this function to read data from your google sheet. Once you have the data in your MATLAB analysis, you can use thingSpeakWrite to write a value into a ThingSpeak channel. You can completely automate this by scheduling your MATLAB analysis using the TimeControl app to do this on a regular interval.
  5 Comments
BEHNAM MOBARAKI .
BEHNAM MOBARAKI . on 24 May 2022
Thanks for the recomandation. I have a monitoring system that should be installed on a building, sending the data to ThingSpeak IoT in real time. On the other hand I have developed a Matlab algorithm to get the data from ThingSpeak and transfer them to a Google sheet, in real time. The case is that when I turn off the Laptop this process stops as the Matlab algorthm is not working anymore.
Is there any solution for that?? Lets say a Matlab function to use it in the algorithm to make the algorithm keep working for a year, even if the laptop is turn off?!
Regards
Behnam

Sign in to comment.

More Answers (0)

Communities

More Answers in the  ThingSpeak Community

Categories

Find more on ThingSpeak in Help Center and File Exchange

Products


Release

R2019a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!