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!

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.

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.