Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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.

Best answer

Updating Google Sheet Cell without changing existing text

A
  • aJAXBeginner
  • Beginner
  • 5 replies

We are using Zapier for Cloud calling service where phone number and date of call get updated in google spread sheet when we receive call on board line.

Problem: When same customer is calling again and we want to update cell partially keeping exisitng notes + new notes but right now existing data is getting deleted and only latest notes are getting updated.

Example of Solution: Existing notes under note column is “customer called on 02 dec 2022”. After Receiving Second Call, Note Column should be updated as “customer called on 3 Feb 2023” | “customer called on 02 feb 2023” |

 

.

 

 

Best answer by simplifywork

@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!

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

S
Forum|alt.badge.img

@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!

Troy Tessalone
Forum|alt.badge.img+14

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.

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
chanelle
Forum|alt.badge.img+8
  • chanelleZapier Staff
  • Zapier Staff
  • 628 replies
  • February 8, 2023

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! 

Terms & Conditions