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?
How can I update the top row of Google Sheets with new data from email using Zapier?
Userlevel 1
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
Userlevel 7
+14
- Certified Zapier Expert
- 24736 replies
-
18 October 2023
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)
Userlevel 1
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,
Userlevel 7
+14
- Certified Zapier Expert
- 24736 replies
-
19 October 2023
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.