As was foretold, we've added advertisements to the forums! If you have questions, or if you encounter any bugs, please visit this thread: https://forums.penny-arcade.com/discussion/240191/forum-advertisement-faq-and-reports-thread/
Options
Adding data to a Google spreadsheet via email
Figgy
Fighter of the night manChampion of the sunRegistered User regular
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.
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.
0
Posts
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.
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: https://mailparser.io/blog/email-to-google-docs-sheets/ 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.
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.
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