Migrate Your Airtable Database to Notion and Keep Your Linked Records with a Make.com Automation

[@theaccountantguy]

Hi I am looking for a system where I can add, edit/modify added like items, delete line items in Google Sheets and the same will be updated in Notion Database. Is it possible through Make? Btw amazing video.😊

[@XRayAutomation]

Thank you! Possible yes, very delicate and prone to error, also yes.

[@theaccountantguy]

@@XRayAutomation Can we have a video on that. Its required very much.

[@XRayAutomation]

We strongly suggest converting gsheets to Airtable for automation purposes. Honestly, we probably won’t make a video for this subject because it opens up a huge can of worms, and really isn’t a scalable solution. Happy to hop on a 15 minute free call to understand your setup though. Maybe there is a simple fix for you. www.calendly.com/Xraytech/15

[@theaccountantguy]

@@XRayAutomation Okay will look into it

[@piotrula7]

and how import data base from notion to airtable?

[@XRayAutomation]

You’ll need to export the table from Notion as a CSV, then import it to Airtable. It’s a bit complicated though, and we should do a video about it. Added to the video backlog. Thanks for asking.

[@cyberfalcon2872]

@@XRayAutomation I was about to ask this. Please do.

[@GretaBertozzini]

Does this work with moving attachments too?

[@XRayAutomation]

Yup! You could configure something to move attachments too! You can see the full abilities list for Notion & Airtable for Make.com right here: xray.tools/?q=airtable+notion

[@diegolamanno]

Thanks for the guide, Do you have an idea how to make the same process but for a "1 to many relation". If I use the example for a field that has many relations, it constantly overwrites the field. I have tried to passing an array of ids but the integration produces an error. Cheers,

[@XRayAutomation]

Nice question! This sounds like a really interesting problem. Figuring this out together in the comment section could be a bit tricky. But if you'd like some support with this, you can join us during our Open Automation Hours, for free. calendly.com/xraytech/open-automation-hours

[@evanjolley8696]

Thanks for this video! I have a quick question. Is there any way to automate the entire process without a CSV while still preserving linked records (i.e. pull from Airtable, rebuild relations, and create items in Notion)? I'll be updating at a scale that I won't want to manually do CSV each time. Thanks again for the video!

[@XRayAutomation]

Absolutely! doing the whole thing programmatically is possible, just a bit more complicated if you're not already syncing your Notion information to Airtable. The trick of the whole thing will be the 'key' that you use to 'find & update' the notion pages. We could discuss on a call if you'd like: www.calendly.com/xraytech/15