My greatest passion is Google Apps Script and in particular document workflow automation within Sheets, Docs, Gmail, Forms, Calendar, BigQuery, Google Data Studio and any other Google Apps.
A general example of systems I have implemented through Google Apps Script:
1. Document Automation
- pull data from a webpage (RSS, CSV, XML, ZIP, TXT, web scraping) or API,
- process that data (calculate, mix with other data, filter, etc),
- put the data into predefined templates (like mail-merge),
- create a custom folder on a Google Drive and name it as needed,
- save documents in an editable format, and
- email them to the client as PDFs up to 500 times a day.
2. Agency Invoicing (again all with Google Apps Script)
- get the data from the project tracker API
- sort the data by the vendor who provided hourly services
- calculate the final invoices per vendor
- push the invoices to the QuickBooks API
- send an automated email to company bookkeeper with those new invoices
3. Project planning and reporting
- an employee goes to the WebApp based on Google Apps Script that just looks like an online form
- employee selects the report s/he needs and submits the form
- the script picks up the data for a particular client from the Google Drive, Asana API, Trello API, and company SQL database
- sorts and filters the data by time and relevance
- pastes data into the Doc template
- creates the PDF file and saves it on the Drive
- creates an entry in the Log Journal on who requested what and when
- send the PDF file to the employee email.
APIs I worked with:
- EOD Historical Data API;
- Market Data API;
- Stripe API;
- Asana API;
- QuickBooks API;
- Harvest API;
- ClickUp API;
- Cerbo API;
- Intercom API;
- Trello API;
- Github API;
- WordPress API;
- Facebook Atlas API;
- Upwork API;
- Google Places API, Place Details API, Maps API, My Business API;
- Google Analytics API;
- Typeform API;
- Instapage API;
- CryptoCompare API;
- Bittrex API;
- LoanCirrus API;
- Bullhorn API;
- Invenias API;
- Swagger API;
- ActiveCampaign API;
- Ameritrade API;
- AgileCRM API;
- LassoCRM API;
- [login to view URL] API;
- Custom API development and testing;
- MySQL connection to Google Sheets through JDBC
Found a method to collect user data from Google Groups (50.000+ members), when nothing else works.
I have extensive experience with the development and management of in-house web applications based on Ruby on Rails, PostgreSQL, Amazon AWS S3, Google Cloud, Heroku, jQuery, HTML5, CSS3, etc.
Watch the video presentation of StartDeck Add-on linked in the portfolio, when you see the Navigation Tab in the Google Doc sidebar, all functionality there was developed by yours truly:
- youtube video embeds into a Sidebar,
- live table of contents in the Sidebar
- toggle between numbered and unnumbered lists.