I am using the Particle Asset Tracker and have IFTTT checking events on the Particle Console every Ten Minutes. IFTTT then posts the “event” (Latitude, Longitude, Time and date) on a Spreadsheet in Google docs. I have several questions:
- When the event takes place, it shows the accurate time in the Particle Console. This event took place at 3:46 PM as shown in this picture. IFTTT then checks for events as shown in this picture.
However, once IFTTT posts the event into the Google Docs Spreadsheet, it shows the event to have taken place 5 hours ahead of time. In this case, it shows it to be 8:46PM.
Is there a way to rectfify this via the code in the IDE or via IFTTT? If not, does anyone know how to write an excel formula into the IFTTT ingredient for date and time as shown here that would subtract 5 hours from the one posted?
I would like to add a column in the spreadsheet that takes the coordinates and makes them a hyperlink to google maps rather than having to copy and paste the numbers into Maps. Is this possible?
Totally aside from IFTTT, if anyone knows how to take this information from google docs and mash it up real time with google maps, I would be very appreciative. Thanks in advance.