Skip to main content

Hi !

I struggle to import data from a bigquery table to another table in Airtable.
My connections are fine, but I can’t manage to map the field between bigquery and airtable in Make. Any tutorial or idea ?

I just want to import or upsert the data from bigquery to airtable. The fields are the same and ready in airtable.

I've tried Skyvia but it make several errors when upserting...

Thanks !

Your best bet is to use Make’s BigQuery modules along with Make’s Airtable modules.

Make has an upsert module for Airtable. If you need help using it, check out this episode of the BuiltOnAir podcast where I talk about importing files into Airtable:

https://www.youtube.com/watch?v=cMA4GPj4iNE

If you’ve never used Make before, I’ve assembled a bunch of Make training resources in this thread. For example, here is one of the ways that you could instantly trigger a Make automation from Airtable.

I also give live demonstrations of how to use Make in many of my Airtable podcast appearances. For example, in this video, I show how to work with Airtable arrays in Make.

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld 

Hello,

I've managed to sync BigQuery to Airtable via Skyvia. Their support team was very helpful to assist me with that integration. You can read more about the available types of mapping here.

Feel free to ask if you need detailed steps or recommendations.

Reply


Terms & Conditions