Denis I.

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.