Upwork home
Sign up
Project Catalog
DesignDesign
Video & AudioVideo & Audio
Development & ITDevelopment & IT
MarketingMarketing
Writing & TranslationWriting & Translation
MoreMore

You will get a flexible solution based on Google Sheets

Ilia K.Status: Offline
Ilia K.
Preview imagePreview imagePreview image

Let a pro handle the details

Buy Data Visualization services from Ilia, priced and ready to go.
Ilia K.Status: Offline
Ilia K.
Preview imagePreview imagePreview image

Let a pro handle the details

Buy Data Visualization services from Ilia, priced and ready to go.

Project details

You'll get a flexible Google Sheets solution for any type of requirement. I can develop spreadsheets based on both formulas and scripts.

Listed below are some of my key services.

1. KPI calculation for managers
2. Managerial accounting
3. System of managers' tables with loading of information into the main table
4. Any kinds of visualization in google data studio
5. Automatic sending Gmail from Google Sheets
6. Integration with external services via API
7. Automatic data unloading from xlsx files to google table. By uploading files to Google Drive or from the mail
8. AppSheets app creation

**Price varies for the above services.
Data Tool
Google Sheets
What's included
Service Tiers Starter
$50
Standard
$100
Advanced
$200
Delivery Time 3 days 7 days 14 days
Number of Revisions
345
Number of Graphs/Charts
51015
Number of Variations
123
Data Source Connectivity
Web Embedding
-
-
-
Interactive/Animated Visuals

Frequently asked questions

Ilia K.Status: Offline

About Ilia

Ilia K.Status: Offline
Data Analysis | Google Sheets | Google Apps Script | Sheets API
Jimbaran, Indonesia - 11:02 am local time
I am a professional Google Apps Script developer with more than 5 years of experience

👂 Good communicator, listen & understand clients project.
⏳ Professional always deliver in time and better then expected.
✍🏽 Dynamic Script writer, always deliver program that never bounds you.
💹 Clean and Progressive approach that let's you grow without maintenance of Script.

👉🏽 I love coding and I always consider my client's work my own and ASK questions many times as CONSULTANT during the project so we aren't missing anything & client get's full advantage of the program, he paid for.

Here's what I can do for you:

GOOGLE SHEETS and GSUITE:
- Sheets: Designing complex dashboards & reporting; field lookups, query & format conversions
- Drive: Reading folders and files & list them in Google Sheet for processing
- Forms: Create custom forms for different recipients via Google Apps Script
- Docs: fill a template with Google Sheets data and convert to PDF/Word document/CSV
- Calendar: Create and sync calendar events with data from Google Sheets
- Gmail: send emails, read emails; format & forward emails; designing custom email tracking systems; processing attachments and send them to APIs
- API Integration - Calling the APIs; passing data from Google Sheet to API; populating data into Google Sheet from API

GOOGLE APPS SCRIPT - INTEGRATION WITH API:
Authentication -
simple API key parameter
Basic authentication
OAuth2
Retrieving data via the GET calls from APIs. Performing paginated calls to retrieve very long lists of results in separate calls.
Updating data via POST/PUT/DELETE calls.

I am a friendly, professional, serious, and confident freelancer. I can work independently with a high level of accuracy. I am always seeking opportunities. I look forward to working with you.

Steps for completing your project

After purchasing the project, send requirements so Ilia can start the project.

Delivery time starts when Ilia receives requirements from you.

Ilia works on your project following the steps below.

Revisions may occur after the delivery date.

Gather full requirements

Gather full requirements by text chat or email.

Create the project plan

Create the project plan and discuss it and then finalize it before the start.

Review the work, release payment, and leave feedback to Ilia.