As was foretold, we've added advertisements to the forums! If you have questions, or if you encounter any bugs, please visit this thread:

Adding data to a Google spreadsheet via email

FiggyFiggy Fighter of the night manChampion of the sunRegistered User regular
Is this possible? I want to add a row of data (let's say 6 columns, strings) to a spreadsheet by sending an email. Then another email, it adds to the next row. And so on.

If anyone could point me in the right direction that would be super helpful, or just tell me I'm nuts and this can't be done.

XBL : Figment3 · SteamID : Figment


  • Options
    bowenbowen How you doin'? Registered User regular
    I don't think it is with built in tools, you could theoretically make something like that with their API and a programming language.

    not a doctor, not a lawyer, examples I use may not be fully researched so don't take out of context plz, don't @ me
  • Options
    localh77localh77 Registered User regular
    I actually started looking into this a month or two ago, but I haven't had the time to write something yet. The first answer on this page was what I found as a start:

    It isn't terribly elegant, but it looks like it's a matter of having an email filter tag incoming emails with a certain label, then having a script periodically run and read through each message with that label.

    It's nice because it doesn't look like it requires any fancy extensions, just email filters and Google scripts. But it would be nicer if it could somehow be triggered automatically when a certain email comes loan. But I haven't figured that out yet.

  • Options
    GrobianGrobian What's on sale? Pliers!Registered User regular
    edited May 2017
    If you are coding a script like localh77 describes, then my next question would be why you use email in the first place. Google scripts can be published as a web app which can then be called from other applications or whatever. Even just calling a URL like
    to send the strings and then process them in the script like the stackoverflow solution

    At a glance it didn't look like Google scripts have a trigger for incoming emails, so you would need to do something timebased (e.g. check every 30 minutes if something came in) and I don't know how often they allow you do run it (edit: seems to be once per hour?). The web app approach allows immediate updates to the spreadsheet whenever a request is fired off.

    Also taking another step back: I assume you want to generate the email automatically somewhere? Because otherwise you could just use a google form to populate a spreadsheet.

    And now I just found this by accident: That's a commercial solution for the problem. Looks expensive to me, but you didn't specify what this was for and maybe you have a budget but no coding know-how.

    Grobian on
  • Options
    FiggyFiggy Fighter of the night man Champion of the sunRegistered User regular
    Specifically, having MailChimp (email marketing software) synced with a Google Sheet took for new entries to add to a subscriber list.

    Then emails are sent whenever someone opts in via one of many web forms. This avoids custom development making the web form software integrate with the marketing software. It's possible that way, but I thought there might be an easier way.

    XBL : Figment3 · SteamID : Figment
  • Options
    cls357cls357 Registered User new member
    Figgy wrote: »
    Is this possible? I want to add a row of data (let's say 6 columns, strings) to a spreadsheet by sending an email. Then another email, it adds to the next row. And so on.

    This thread is a bit old and probably you have already found a way to do that but just in case here it is a step by step explanation:

    Email to excel with Email Parser

Sign In or Register to comment.