IFTTT + Google Spreadsheet

Hey Folks!

we are connecting our photon particle wih Google Drive, so we ran into an issue, basically what we are looking is to get in google drive the entire date posted in our particle cloud but there the data is missing a portion of the string, here is an example of the issue:

Particle cloud:
Published At: July 2nd at 3:10:18 pm

IFTTT:

using the CreatedAt funtion what we get in google drive is:

July 2, 2015 at 03:10PM

so as you can see we are not getting the last portion of the event which is the seconds (18)

so in order to overcome this issue what should we do? could you please help us??

your help is well appreciated

Thanks in advance
Jovan
Application Engineer
Concise Fabricators

It seems IFTTT only provide hour+minutes in the CreatedAt event. What you can do is publish the time (with seconds) as an event. When the event is received, you can trigger the IFTTT to log it in Google Drive. If you use {{EventContents}}, you can insert the time in your file.

2 Likes

Hi thanks for your answer, you have an example that could share me what this commenting me.

Jovan Amaya

I didn’t test, but you might be able to use something like this:

Spark.publish( Time.timeStr() );

Back in IFTTT, the {{EventContents}} should contains something like Wed May 21 01:08:47 2014

So the publish event already includes a timestamp, and the CreatedAt property we send IFTTT is an ISO date string, so it includes seconds / hundredths of a second (I think).

If you used Webhooks you’d have full control over what gets sent to Google ( http://docs.particle.io/photon/webhooks/ ), or maybe we can ping the Googlers on the forums, and see if there is anything they can do on their end. :slight_smile:

Do you have any control over the date formatting in Google Drive? Or is that literal formatted string being sent? (I think IFTTT sends the full date when triggering an action on a channel, so Google should be getting the seconds data)

Thanks,
David