@aJAX I’m pretty sure the best way to make this work will be to make some edits to the Google Sheet you’re using. While technically possible to set this up exactly how you asked, that setup will cause issues in the future as the call list gets longer and longer.

Instead, I’d recommend setting up the sheet so each call gets logged in a different row, and then use a dropdown + filter formula to find all the related call info for any customer.

Here’s a sheet with an example of what I mean.

Setting it up like this should be much more scalable, since it will make all notes and customer reference far more readable than if you try to add a growing list of customer records to a single cell.

With that said, if there’s some reason why the info has to be all contained in the same cell, please let me know and we can work through some other options!

Hi @aJAX 

Good question.

I’d recommend using Airtable instead of GSheets: https://zapier.com/apps/airtable/integrations

Airtable is a relational database, meaning records can be linked together.

You’d have 2 Tables in 1 Base. (Contacts, Logs)

Call Logs can be linked to Contacts.

Hi @aJAX , looks like you have two great options for tackling this issue. Let us know if you have any questions on setting up your Google Sheets properly or getting the Airtable Zap together!