Hello, right now I have the data that comes from an email to go to a google sheet. However the data that comes in goes to the bottom. Is there a way to have it update the top row so the old data pushes down each time?
Question
How can I update the top row of Google Sheets with new data from email using Zapier?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Orchestrator & Solution Partner
Hi
Good question.
New rows will be added to the bottom of the GSheet.
Have you reviewed the available help articles for using GSheets in Zaps?
https://zapier.com/apps/google-sheets/help
I’d recommend using Airtable instead of GSheets.
Airtable has Views, which are segments of data. (sort, filter, group, reorder fields, show/hide fields)
Never heard of Airtable I will look into it. Would it work for something like this situation. We receive emails with transcripts of phone calls. I then grab those transcripts and add the information in a google sheet for the rest of the company to see. I just wanted a way for everyone to keep up on phone calls and if we completed the task from that call.
Thank you,
+14- Zapier Orchestrator & Solution Partner
Airtable sort view help article: https://support.airtable.com/docs/sorting-records-in-airtable-views
Airtable Views can be shared externally via links or embedded: https://support.airtable.com/docs/using-the-view-share-menu-in-airtable
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.