Upwork home
Sign up
Secondary
Hemanta A.
Kathmandu, Nepal
100% Job Success
Top Rated

Google Sheets and Google Apps Script Expert

Working for more than Seven years as a Data Analyst and Business Analyst, I have enjoyed my ever-growing passion for data. I have been freelancing in Upwork for more than 6 years and gained several happy clients. I am also a data consultant for several clients in the USA, Canada, and Europe. I seriously respect my client's confidentiality. I perceive tables and data as raw materials in a production line that produces a final product called information which one uses as a commodity for their business. I build machines to process those data, using tools like Google scripts coding and Python. Google Sheets and Scripts coding is one of the cheapest, simplest, and easiest ways any business can handle and process its data. That is where I am proving my expertise. Moreover, I have also developed professional-level skills in Python and Matlab for more complex and time-consuming computation of data. What I believe: - Every frequent copy-paste work can be automatized. - If you are doing repetitive tasks on the computer every day, you are not working smart. - For many tasks, Google Sheets can be programmed such that it eliminates the need to buy costly software. - Google Sheets is a versatile internet-based platform. You can connect its data with Google Forms, Google Docs, calendar, Google Slides, database, and several web-based applications like Firebase, Data/Looker Studio, google/Facebook ads, salesforce, android apps, etc. - Google Sheets/scripts is eliminating the need for Microsoft Excel and Macros in the Business/ Corporate sector. What I do : 1. Make visually appealing dashboards in Google Sheets with powerful data computation capability. 2. Data handling, management, processing and visualisation in Google Sheets and script. 3. Make interactive Google sheets through in-built formulas, Custom built formulas and complex coding 4. Integrate Google Sheets with other web-based platforms through API integration. (JSON and XML). 5. Suggest businesses restructure their sheets for optimization and easy data handling. 6. Integrate Google Sheets with other Google apps like Gmail, Google Calendar, Google Docs, Google Slide, Google Forms and other spreadsheets. 7. Integrate Google sheet with BigQuery, SQL databases, python, desktop applications and other web platforms. 8. Create triggers to run tasks automatically. Projects Completed - Google Workspace Business Process Automation - Open AI: Using Open AI API to accomplish what it offers- text completion, summarization, language processing, chatGPT, image generation, embeddings, and moderation. - Project Coin: A Google Sheets dashboard for cryptocurrency trading, which makes API call to several cryptocurrency websites, fetch the desired data and interpret them and get optimized business data. -Google ads/ Facebook ads management: A spreadsheet project to fetch data from Google Ads and Facebook ads (API integration) and manage the data. -Comparison graph project: An interactive Google Sheets project which makes multiple graphs based on dynamic inputs and dynamic data validations. - Google Sheet Consulting: Complete Google Sheets solutions (dashboard creation, automation, optimization and external integration ) for companies located in Canada, UK and Australia. -Financial data analysis in Google Sheets. -Simulation of courier data in Google Sheets. - Integrate E-commerce (Bigcommerce and Shopify) data to Google Sheets. - Integrate google sheets or apps with several APIs such as Slack,Tink, Monday, webhose, NewsApi, Datanews, Nimble, Mailchimp, Mailshake, BOL, Bigquery, Google search Console, Tune, Google Natural Language Processing (NLP), IBM watson Natual Language Understanding (NLU), hubspot, Serp Api, Twillo, gohighlevel, newsapi, parsehub, webhose, bigquery, google search console, OCR, semrush, Open AI, etc. Expertise in Outh2 authorization, REST/SOAP API with JSON and XML response handling. - Python-based web applications. - Google Apps Script-based web applications with custom interface using HTML, CSS and Javascript. -several web apps using Google Apps script with Google Sheets as a database. -speech recognition and voice interface web application using apps script with Google Sheets as data storing platform. -office management system (inventory, payroll, report generation) -Managing Google Drive files and making custom scripts. -Optimization problem solving with Operational Management technique (simplex method- mathematical approach) -Cryptocurrency and ticker/stocks data analysis system -Project Management System (Medical, real estate, and health services) -Building custom web apps based on Google Apps Script. -Building add-ons for Google Sheets. - Payroll management - Calendar Events Management -Big data analytics of US community-based organizations (CBOs) using python
Work history
Hemanta A. has more jobs. Create an account to review them
Skills

Skills

  • API Integration
  • Python
  • JavaScript
  • Google Apps Script
  • Google Sheets
  • Macro Programming
  • JSON API
  • ChatGPT

Get started working with Hemanta quickly with these predefined projects.

Get started working with Hemanta quickly with these predefined projects.

You will get PDF report generating system

From $150
1 day delivery

You will get a solution to execution time-out error in Google Apps Script

From $100
1 day delivery

Browse similar freelancers