About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

  • Home
  • Get Help
  • How Do I
  • - Google Sheets to Notion 2-way sync - Lookup Spreadsheet Row unable to find match
Question

- Google Sheets to Notion 2-way sync - Lookup Spreadsheet Row unable to find match

  • 18 November 2021
  • 5 replies
  • 203 views
P

Good morning everyone,

 

I’m struggling to set up my Zapier, I would like to have a 2-way synch between Google Sheets and Notion. I was able to to set the Google Sheets to Notion Zap but I can’t do the same for the other way around.

I already checked for sharing permissions and compatibility (so went through the Token process and everything) but what stops me is the Lookup Spreadsheet Row.

What I want to do is having one column (if not the entire file) sending the input from Notion to Google Sheets.

Is there anyway to solve this?

 

Zap blocks
Error in the Lookup (2nd step)
File on Sheets
File on Notion

 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

5 replies

jayeshkumarbhatia
Userlevel 6
Badge +6

Hey @Peperit ,

 

Can you add some data in Google Sheet and than try? Since the data is missing, that it will fail.

 

 

 

P

Hi @jayeshkumarbhatia,

Thank you for your interest. I had already put data but it’s not working.

 

 

jayeshkumarbhatia
Userlevel 6
Badge +6

Hey @Peperit ,

 

Can you add exact same values in Google Sheet and than try again?

 

In Lookup the values should also match.

Troy Tessalone
Userlevel 7
Badge +14

Hi @Peperit 

Zapier is not meant for 2-way data syncs: https://zapier.com/help/create/basics/does-zapier-support-two-way-syncing

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
jboyski

Hey @Peperit,

Are you trying to update rows in Google Sheets from Notion entries that were originally created in Notion from Sheets rows? (i.e. a 2-way sync that starts from GSheets).

If so, maybe try this.

When you first create the entry in Notion from the Sheet info add a final step to the Zap that sends the Database Item ID of that newly created entry back to Sheets. You’ll need to create a new column in your sheet to contain this info.

Then when Notion tries to push info to Sheets you can use that Database Item ID in the lookup to find the matching data.

If you’re trying to create data in Google Sheets from Notion entries that were not originally pushed to Notion this however won’t work.

I haven’t tested this but let me know if this works.

Terms & Conditions