Hi,
I have google contacts where I want to update my notion customer database with the GoogleContactID. This would be a basic relational join if we had. I have a notion customer database with CustomerName and a column called GoogleContactID and want to join on CustomerName and Display name from Google Contacts as they should be equal. (Join Key) and update the field. Please see the below loom. I believe I need to use an array agg with get() and match() but can’t figure out the join/matching of id’s so I can process one array against the other to update the database. Please see the below loom.