Automation only partially working

[Bianca_Kearney]

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!

[Vivid-Squid]

Hi Bianca,
Are there any error messages in Zapier?

[Bianca_Kearney]

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.

[Bianca_Kearney]

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.