Skip to main content

Automation only partially working


Hi, I am new to airtable, I’m creating a zapier automation from airtable to google sheets transferring data from a view (which is locked so no changes can be unwittingly made), when I test within Zapier the record fills into google sheets correctly but when its running later by itself it only transfers over 3 or 4 out of the 8 fields to be mapped, so in principle it works but there is some issue on collecting the data. The fields missing are dates, text and currency fields that i formatted in. google sheets, which is what I am wondering is causing the problem. Can anyone direct me as to what things to check? Thanks!

3 replies

  • Inspiring
  • 532 replies
  • April 1, 2022

Hi Bianca,
Are there any error messages in Zapier?


  • Author
  • Participating Frequently
  • 7 replies
  • April 1, 2022
Vivid-Squid wrote:

Hi Bianca,
Are there any error messages in Zapier?


No, reading up on it something that might be happening is that its passing the data over before I’m finished filling it in in the original location.


  • Author
  • Participating Frequently
  • 7 replies
  • April 1, 2022

Scrap that, did a test and it didn’t update until it was finished, I think its because I have formatted the google sheet columns and then its not able to map them! But without the end format they don’t work for me.


Reply