Error using google sheets

Cloud Integrations
1

Hello
Im trying to send temp values from the photon to google sheets
It show this error on the applet

image
image1575Ă—2100 109 KB

Help?
Thks

2

Hi @Lagartus

It looks like you are missing the event name from your IFTTT setup. In mine that works, it says:

If MyDevice published Temperature, then add row to spreadsheet in username@gmail.com's Google Drive

Where Temperature is the event name that is published in my device like this:

 sprintf(tempStr,"%f",temperatureFloat);
 Particle.publish("Temperature", tempStr);
1 Like
3

Hello , finally I fixed the IF, photon publishes correctly
See pic

I cannot make it create the g.sheet
See pic,

Whats wrong?

image
image1668Ă—2224 310 KB
image
image1668Ă—2224 220 KB

4

any help please?

5

HI @Lagartus

In the pictures above, it looks like everything is working fine. Can you explain in more detail what you expected to happen and what is not happening.

6

it does not create the sheet nor uploads any info to google drive.

7

In my working example, I have:

Spreadsheet Name:  <EventName>atMyDevice
Formatted row: <EventName>|||<EventContents>|||<DeviceName>|||<CreatedAt>
Drive folder path: events

So I create the sheet “TempatMyDevice” in the folder “events” and put four times into each row for each event.

I don’t recall if the folder and the sheet have to exist before your run this, but it doesn’t hurt so I would try creating them ahead of letting this run.

1 Like
8

Hello, still struggling with this

Ive created
Particle.publish(“Temp_Published”, temperatureCurrent4String);

So " Temp_Plublished" it show correct temp

For some reason, the data gets lost halfway and does not create the sheet/ row

Any suggestion?

9

Hi @Lagartus

I would try publishing something that you know will work as a test like,

Particle.publish("Temp_Published","1.00");

And make that works.

10

I think the “if” works correctly
I did the modification

then
then391Ă—813 42.2 KB
temp%201
temp%201881Ă—189 17.4 KB
if
if397Ă—697 21.1 KB

nothing is created in google sheets

11

Hi @Lagartus

I think you have a couple of errors in your setup there.

  1. You are creating a new spreadsheet for every value (EventContents) and I do not think that is what you want. The Spreadsheet name should be just EventName.

  2. You are not formatting the row correctly. You need to add “|||” between the DeviceName, CreateAt, EventContents, and EventName items in the formatted row.

12

ok, i followed your guide

it shows:

error%203
error%203504Ă—668 14.7 KB
error%204
error%204828Ă—1770 90.9 KB

thanks

13

Hi @Lagartus

Not EventContents for the spreadsheet name–you need EventName or something else. Otherwise you spreadsheet will be named “1.00” which seems silly. You can have more things in the formatted row, if you separate them with three vertical bars ("|||").

1 Like
14

Sorry, Ive made all tests posibble
I think data does not get to google sheets.
Ived verified permissions and all are ok
This is my last screen

error%205
error%205380Ă—719 31 KB

Maybe there was a change now with sheets permissions
thanks in advance

15

OK I just tried mine again and it works fine. You must have given IFTTT your permission to use your Google account and you must turn on the recipe. Here are some screenshots:

IFTTT1
IFTTT1392Ă—625 15.6 KB

IFTTT2
IFTTT2392Ă—834 22.1 KB

Here is the Google sheet in my Google Drive. You can see I ran it in April and again just now. The device publishes a “Temperature” event every minute.

SpreadsheetCap

16

I did finally find the problem
The recipe works fine.
The confusion is where the sheet is created.
Dont look in the google drive folders.
You need to log in into the gmail used in the recipe, and look there into the sheets
Voila !
I hope this helps for a newbie like me !