Profile cover photo
You're now following
Error following user.
This user does not allow users to follow them.
You are already following this user.
Your membership plan only allows 0 follows. Upgrade here.
Successfully unfollowed
Error unfollowing user.
You have successfully recommended
Error recommending user.
Something went wrong. Please refresh the page and try again.
Email successfully verified.
User Avatar
$70 USD / hour
Flag of TURKEY
istanbul, turkey
$70 USD / hour
It's currently 12:41 PM here
Joined May 24, 2013
1 Recommendation

Denis I.

@Denisakov

5.0 (11 reviews)
4.6
4.6
91%
91%
$70 USD / hour
Flag of TURKEY
istanbul, turkey
$70 USD / hour
100%
Jobs Completed
100%
On Budget
100%
On Time
10%
Repeat Hire Rate

Google Apps Script, Automation Expert, API Dev

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.

Contact Denis I. about your job

Log in to discuss any details over chat.

Reviews

Changes saved
Showing 1 - 5 out of 11 reviews
Filter reviews by:
5.0
$360.00 USD
Denis is a great communicator and showed that he is highly skilled for our advanced Google App Script / mySQL Query needs. He took the time to not only listen to what we asked for, but also to understand what we really needed. This led to an end product that was way better than what we had originally envisioned. Would highly recommend!
JavaScript
Web Scraping
Google App Engine
Mac OS
Data Mining
+1 more
User Avatar
Flag of Scott H.
@scotthill
5 years ago
5.0
kr1,600.00 SEK
Great service.
Google App Engine
Google Web Toolkit
S
Flag of Sebastian S.
@sebastian45
7 years ago
5.0
$833.25 AUD
smart developer, honest and helpful
Cocoa
Mac OS
Objective C
I
Flag of David C.
@indemnitydave
7 years ago
5.0
$262.50 USD
I'm not done yet - but the work is stellar so far
JavaScript
Web Scraping
Google App Engine
Mac OS
Data Mining
+1 more
User Avatar
Flag of Curtis P.
@curtispalmer
7 years ago
5.0
$111.00 AUD
Denis was able to advise on hardware and software requirements as well as define custom software. He was able to estimate time to develop software and recommend an implementation timeline
Google App Engine
G
Flag of Geoff O.
@geoff91
8 years ago

Contact Denis I. about your job

Log in to discuss any details over chat.

Verifications

Preferred Freelancer
Identity Verified
Payment Verified
Phone Verified
Email Verified
Facebook Connected
Previous User Next User
Invite sent successfully!
Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.