From Google Sheets to ThingSpeak

2020 6 25
1 个回答
回答已采纳
更新时间：2022 5 24
11 次查看（30 天）

0 个投票

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?

请先登录，再回答此问题。

 采纳的回答

Vinod
Vinod 2020-6-26

2 个投票

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 个评论
显示 3更早的评论 隐藏 3更早的评论

Vinicio Moya
Vinicio Moya 2020-6-29
Thanks Vinod.
I´m two days trying to make ir works, but I have some problems.
1) Now, I have the data in a Matlab Analysis like you told me. It works perfect.
But, 2) When I try to send it in the ThnigSpeak Channel woth the thingSpeakeWrite, the system give me an error: "error using Tilt1 Google (line 36). 'Values' value must be an array or a table.".
The data is something like this:
ans =
325×7 cell array
{'Timestamp' } {'Timepoint'} {'SG' } {'Temp'} {'Color'} {'Beer' } {'Comment' }
{'6/27/2020 7:31:02'} {'44,009.69'} {'1.001'} {'78' } {'RED' } {'Prueba 1'} {0×0 double}
{'6/27/2020 7:31:14'} {'44,009.69'} {'1.001'} {'78' } {'RED' } {'Prueba 1'} {0×0 double}
{'6/27/2020 7:32:09'} {'44,009.69'} {'1.00
How can I write the first Column in the Channel 1 Field 1, the second in the Channel 1 Field 2, etc...?
Vinod
Vinod 2020-7-2
As the error says, you need to convert your cell array from the Google sheet into a table.
SGTable = table(ans(:,1), ans(:,3),'VariableNames',{'timestamp','SG'}) % where ans is the cell array you got back from reading the google sheet
Now, you should be able to use thingSpeakWrite to get the data in SGTable to ThingSpeak.
BEHNAM MOBARAKI .
BEHNAM MOBARAKI . 2022-5-23
Hi. Could you please explain how to do the opposit? I need to send the data from one channel of ThingSpeak to the Google sheets.
Regards
Behnam
BEHNAM MOBARAKI .
BEHNAM MOBARAKI . 2022-5-24
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

请先登录，再进行评论。

更多回答（0 个）

社区

更多回答在  ThingSpeak Community

类别

在 帮助中心 和 File Exchange 中查找有关 ThingSpeak 的更多信息

产品

版本

R2019a

标签

Community Treasure Hunt

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

Start Hunting!

Translated by