I have a Notion database and a Google spreadsheet that each have a list of client names. I want to cross-reference the names and check if they share entries (if there's a "match"). Is there a way to do this on Notion by uploading the Google sheet as a CSV, and then creating a formula to check if the two databases share an entry? Thanks!
Connect
Notion Answers
Help between Notion users
Register & Ask
It's free & easy
Get answers
Answers, votes & comments
Vote and select answers
Receive points, vote and give the solution
Question
1 Answer
I would recommend doing it the other way around by exporting Notion database into CSV and comparing it in Google sheet.
While there are ways to detect duplicates but it requires extensive setup of rollup and relations which will require more effort than needed.
Alternatively, you can use a tool like Sheets2Notion which will sync your Notion to a Google sheet and you can compare there using Google Sheet formula.
Then again the simplest would be to just export from Notion to Google Sheet.
Without Answer
-
- 45
- 0
- 3 days ago
-
- 124
- 0
- Mar 8
-
- 159
- 0
- Feb 21
-
- 154
- 0
- Feb 14
-
- 201
- 0
- Feb 13
-
- 183
- 0
- Feb 11
-
- 205
- 0
- Feb 8
-
- 349
- 2
- Feb 3
- see all
Recent Activities
GettingSavvy_ asked 3 days ago
Summarising transactions by week and until current…amandabee selected an answer Feb 24
Can I use a button to create a calendar event for …Barbora commented Feb 24
The Filters in the databases don't disappear.jwpeng asked Feb 21
Count keyword
...