Google App Engine PHP script to process email and send data to a Google Sheet -

-

our water district sends out automated alarms , process statistics scada computer in our water treatment plant. information sent in form of sms messages , daily emails csv file attachments. because have informational website on google sites, automatically display real-time process statistics on our website in simple google sheet automatically updated.

i have been handling sms alarms through custom php/twilio scripts separately hosted, integrate in google cloud google appengine. think can accomplished in variety of ways, , evaluating alternative automation approaches using php , gmail api. google cloud/appengine noob, have couple of architectural questions:

  1. can accomplish automation enabling google sheet incoming mail , processing data through spreadsheet scripting? if elect approach, can google sheet receive email directly, or must send email data sheet http request?

  2. alternatively, google cloud more reliable , robust platform automation? examples have seen, looks appengine php scripts can enabled receive incoming email, parse required data email body or attachments, , form appropriate web request directed google sheet endpoint. under approach, google sheet scripting minimal.

does have constructive advice before plunge blindly , lustfully headlong project? thanks.

to answer questions:

1/ using google scripts

i think using google spreadsheet scripting might option if data stored in body text of e-mail.

in case write google spreadsheet script pulls e-mails directly gmail account. instead of sending e-mail spreadsheet access gmail account gmailapp service.

however ... if data stored inside csv attachment i'm not sure if feasible. i'm not sure can access data inside attachments google spreadsheet script.

2/ using google cloud

i'm no means expert here. think don't need host code them. once use php , leverage google apis (gmail + google sheets) should able host code anywhere like.

extra: consider using email parser software

developing feasible take sure lot of time. e-mail bit difficult handle , have lot of moving parts there.

i'm founder of mailparser.io , believe better of using ready made e-mail parser software ours job. integrate natively google spreadsheets , should have running within couple of minutes.


Comments

Post a Comment

Popular posts from this blog

java - Run spring boot application error: Cannot instantiate interface org.springframework.context.ApplicationListener -

-
i have spring project , try make use spring boot , run @ embadded tomcat following : https://spring.io/guides/gs/rest-service/ this application //@configuration //@enableaspectjautoproxy @springbootapplication @componentscan(basepackages = "gux.prome") public class application { public static void main(string[] args) { springapplication.run(application.class, args); } } if use maven command: mvn spring-boot:run , project starts fine, need debug , run main method @ intelij, exception occurs: exception in thread "main" java.lang.illegalargumentexception: cannot instantiate interface org.springframework.context.applicationlistener : org.springframework.boot.logging.classpathloggingapplicationlistener @ org.springframework.boot.springapplication.createspringfactoriesinstances(springapplication.java:414) @ org.springframework.boot.springapplication.getspringfactoriesinstances(springapplication.java:394) @ org.springframework.bo...
Read more

reactjs - React router and this.props.children - how to pass state to this.props.children -

-
i'm using react-router first time , don't know how think in yet. here's how i'm loading components in nested routes. entry point .js reactdom.render( <router history={hashhistory} > <route path="/" component={app}> <route path="models" component={content}> </route> </router>, document.getelementbyid('app') ); app.js render: function() { return ( <div> <header /> {this.props.children} </div> ); } so child of app content component sent in. i'm using flux , app.js has state , listens changes, don't know how pass state down this.props.children. before using react-router app.js defines children explicitly, passing state natural don't see how now. using couple of react helper methods can add state, props , whatever else this.props.children render: function() { var children = react.ch...
Read more

Excel VBA "Microsoft Windows Common Controls 6.0 (SP6)" Location Changes -

-
i have excel workbook used generate quotations customers. there main page user inputs data, , there buttons generate various pdfs , send them customer. however, 1 user consistently getting error preventing generating , sending pdfs. i beleive "microsoft windows common controls 6.0 (sp6)". it's installed on users' computers. on mine, location "c:\windows\syswow64\mscomctl.ocx" on others "c:\windows\system32\mscomctl.ocx" the user experiencing issues on 32-bit machine, "mscomctl.ocx" file should in system32. have manually put in there, , pointed common controls reference in vba it. issue seems keep reverting looking in syswow64. since folder doesn't exist, can't find it, , can't produce pdfs. i thought perhaps issue user running older version of office (2007) there users on 2013 , 2016. thought perhaps mixture of 64-bit , 32-bit users. user gets sent workbook other users (as quotation process goes further, gets passed ...
Read more