Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Re: BigQuery —–TO ——>>>>>Airtable

Solved
Jump to Solution
332 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Nocode34130
5 - Automation Enthusiast
5 - Automation Enthusiast

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 !

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

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 

See Solution in Thread

airtable #on2air #builtonair 7/18/2023 - BuiltOnAir Live Podcast Full Show - S15-E02 ___________________________ The BuiltOnAir podcast is a live weekly show highlighting everything happening in the Airtable universe. Check us out at BuiltOnAir.com/join. Join our community, join our Slack channel
2 Replies 2
ScottWorld
18 - Pluto
18 - Pluto

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 

airtable #on2air #builtonair 7/18/2023 - BuiltOnAir Live Podcast Full Show - S15-E02 ___________________________ The BuiltOnAir podcast is a live weekly show highlighting everything happening in the Airtable universe. Check us out at BuiltOnAir.com/join. Join our community, join our Slack channel
MJen
6 - Interface Innovator
6 - Interface Innovator

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.

Mary Jennings