Can't seem to watch rows in BigQuery and create records in Airtable

I have an email report that gets piped into BigQuery every day. The goal is to get that new data daily piped into Airtable. I have set up a BigQuery Watch Rows and connected it to an Airtable Create Record and mapped the relevant fields from BigQuery into Airtable columns.

The BigQuery module seems to run fine (it pulls a limit of 5 records at the moment, and previously it would flow into Airtable and then throw and error saying the record ID didn’t exist (not sure how this could be, as it is creating a record and not trying to find one):

However I disconnected and reconnected, and now the Airtable module never seems to run. Not sure if I am missing a step or something for it to even run, but then when it does, how do I get it to create a record in Airtable? Thanks for any help in advance!!

Hello,

Please create a new ‘Create a Record’ module with new connection.

If issue persist try looking at request - response logs via Make Dev tool.

Hope this points you in the right direction, thanks.

2 Likes