Automation only partially working

Topic Labels: Automations
774 3
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

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 3

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.

5 - Automation Enthusiast
5 - Automation Enthusiast

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.