Hemanta isn't taking new orders for this project right now. Here are some similar projects to explore.
You will get a solution to execution time-out error in Google Apps Script
Top Rated
You will get a solution to execution time-out error in Google Apps Script
Top Rated
Simple Solution
Get a quick fix to the problem and keep your script running without error.
- Delivery Time 1 day
- Number of Revisions 2
1 day
delivery —
Nov 6, 2024
Revisions may occur after this date.
Hemanta isn't taking new orders for this project right now.
Loading
Upwork Payment Protection
Fund the project upfront. Hemanta gets paid once you are satisfied with the work.
Project details
Google Apps Script is the underlying script in Google Apps, especially Google Sheets. Google Apps Script is limited to a maximum of 6 minutes of execution time to save resources. In some cases, the script is too complex to be executed within the 6-minute time, especially while processing a large number of rows during data scraping.
I have received quite a large number of offerings from several companies to solve this problem. Therefore, I have started this project offering to serve people and companies who have faced similar issues.
My solution is to first optimize the code to remove any inefficiencies, divide the rows into several batches and process each batch at a time until all the rows are processed. This works by creating a dynamic trigger system dedicated to processing each batch of rows. All of this works automatically after a single click of a button.
I have received quite a large number of offerings from several companies to solve this problem. Therefore, I have started this project offering to serve people and companies who have faced similar issues.
My solution is to first optimize the code to remove any inefficiencies, divide the rows into several batches and process each batch at a time until all the rows are processed. This works by creating a dynamic trigger system dedicated to processing each batch of rows. All of this works automatically after a single click of a button.
Support & IT Services
Cloud Services, Helpdesk & Technical Support, ConsultationWhat's included
Service Tiers |
Starter
$100
|
Standard
$150
|
Advanced
$300
|
---|---|---|---|
Delivery Time | 1 day | 3 days | 5 days |
Number of Revisions | 2 | 4 | 5 |
Remote Connection Support | - | ||
Documentation | - |
Optional add-ons
You can add these on the next page.
Additional Revision
+$50
Remote Connection Support
(+ 1 Day)
+$25
Documentation
(+ 2 Days)
+$30Frequently asked questions
50 reviews
(47)
(3)
(0)
(0)
(0)
This project doesn't have any reviews.
AC
Anfernee C.
Oct 14, 2024
Google Sheets Macro/Automation Developer for Amazon PPC Campaign Management
Amazing developer! Great problem solver~
JM
Jeff M.
Oct 7, 2024
Use API To Pull Data From App To Google Sheets
Hemanta is an great problem solver, and came up with fast and effective data and API solutions. Communication was clear and consistent as well. Would gladly work with him again.
ZS
Zack S.
Oct 4, 2024
Google Sheets Expert
AM
AC M.
Sep 24, 2024
Google Apps Script to send Mass GMaiL messages from a Google Sheet
Project completed successfully
SD
Suman D.
Sep 17, 2024
30 minute consultation
Pro guy when it comes to automation related to google sheet,etc
About Hemanta
Google Sheets and Google Apps Script Expert
100%
Job Success
Kathmandu, Nepal - 2:24 am local time
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
Steps for completing your project
After purchasing the project, send requirements so Hemanta can start the project.
Delivery time starts when Hemanta receives requirements from you.
Hemanta works on your project following the steps below.
Revisions may occur after the delivery date.
Understand your problem in particular
Add scripting to solve the problem