Continuing the discussion from Any Updates on Google Voice Integrations? SMS?:
@Marc_Dillon What would be the Google App Script code/implementation process be to add one set of auto labeled emails from Gmail into a Google sheets table? Thank you very much for responses. I did look through all your history for the code and but there were only posts on exporting gmail attachments, something with sent emails, and csv’s if I remember correctly but it was a lot of content you’ve provided. If I’m mistaken please send me a link to the post.
This table would need to be continuously updating, at the slowest once every half hour and ideally real-time or less than a minute.
I would need from, to, cc preferably, subject, body, images in body, and attachments but if attachments don’t work that’s probably ok.
I’ll reply to these emails which are actually Google voice texts with another email typed by employee with Appsheet which will text the customer, the newly created email gets added to email/comm table, and emails are referenced to customer by phone which is in the last characters of the subject line. Then every customer will have a related communications column with all history of comm, spoken conversation summaries could be added as well.
I could always use mail parsers or Zapier or other integrations but I need to keep cost low and ideally within the Google Universe.
Here are some resources I found which I believe are on topic but not perfect, and I don’t know GAS enough to make it work.
And code for it
And this handy CloudHQ free extension which may be too good to be true but also seems the simplest. Please let me know if anyone has experience with this solution of theirs.
I would greatly appreciate any help I could get on generating this table close to real-time. Thanks.
Edit: this is pretty much what I need. I will try and make it work. I feel a little silly making this post and asking the pros too many questions and eventually finding the answer that was already there.
@MultiTech_Visions attachment to table setup is really nice but I’m sure I’ll run into problems not knowing GAS.
[APPS SCRIPT: Download Gmails to GSheet, using Gmail Filters/Labels](https://community.appsheet.com/t/apps-script-download-gmails-to-gsheet-using-gmail-filters-labels/38184) Tips & Tricks ?
This Apps Script will monitor your Gmail for new emails that match a certain label, and: Add a New Row to GSheet (Time, Sender, Subject, Body) Remove the email from the Inbox Remove the label Optionally add a new label to processed emails This lets you define the email-matching logic using Gmail’s search operators, instead of having to edit the script code. The only thing you have to edit is the label-name to monitor, and the GSheet_ID.