Skip to main content

Import google sheet and preserve timestamps - also api to keep the sheet sync'd w the table

  • December 1, 2021
  • 4 replies
  • 40 views

Forum|alt.badge.img+6

I imported the gSheet and the timestamps don’t transfer even tho I think I have the column formatted as the same date format…
also how to keep the table and the gSheet in sync? thanks

4 replies

Hannah_Wiginton
Forum|alt.badge.img+19

Hey there,

In our On2Air Actions app, we have a Google Sheets Table Sync function

The Table Sync keeps the entire table in sync - from Airtable to Google Sheets

With the Actions app, you also get an additional 60+ features that integrate with Airtable.

Features like creating Google Docs automatically with Airtable data, bulk creating, editing, or deleting multiple records, setting default field values, copying fields, performing financial calculations, and more.

Here’s a full list:


Forum|alt.badge.img+6
  • Author
  • Known Participant
  • December 20, 2021

I have a google form that inputs to google sheets.
I want to keep that sync’d with Airtable

looks like your app doesnt do that


Forum|alt.badge.img+6
  • Author
  • Known Participant
  • January 20, 2022

I have a google form that inputs to google sheets.
I want to keep that sync’d with Airtable

looks like your app doesnt do that


maybe it does update Airtable when there is a new google sheet row added
and it will preserve the timestamp as the primary field
formatted as a time stamp

because AT won’t import that timestamp as time , it is text

, it has a free trial, I will use that and see
thanks


Forum|alt.badge.img+6
  • Author
  • Known Participant
  • January 20, 2022

maybe it does update Airtable when there is a new google sheet row added
and it will preserve the timestamp as the primary field
formatted as a time stamp

because AT won’t import that timestamp as time , it is text

, it has a free trial, I will use that and see
thanks


which bundle does that/
They range from $30- $350/month

my use is fairly simple I think