Fix a Google AppScript Timeout execution error.

$30-250 USD

Completed

Posted

13 days ago

$30-250 USD

Paid on delivery

We operate a Google Sheet that fetches information from another spreadsheet identified in cell C1. Users mark checkboxes in Row A and click "Build Documents." When a user picks multiple checkboxes to generate documents, the Google Script halts after 300 seconds due to an overload. 1. The objective is to devise a systematic workaround to finish processing the document batch without additional manual intervention. For example, here's a replica of the spreadsheet you can use to test your code. [login to view URL] The documents created all appear here: [login to view URL] In the Spreadsheet App Sscript: In "Rahul's Code". 2. Add a line of code to show the created Blank Document to the user before the script proceeds to the next line of code at line 17? 3. When executed, the script should duplicate the specified template document (ID: 13YQYKB2nKmiRwq3fIyNokNU30Iy9hrv9An17F2btvH4) alongside the existing document and Spreadsheet within the same directory. The new copy should be named after the content of Cell H2, followed by the words: " - Evidence", and then it should be placed into the same folder as the other two files. 4. Then deploy the working code to the Original spreadsheet. All bids are final.

Google Apps Scripts

Google Sheets

Google Docs

Project ID: 38074145

About the project

13 proposals

Remote project

Active 9 days ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@rahul62544

$0 USD in 1 day

4.9

(66 reviews)

6.5

13 freelancers are bidding on average $153 USD for this job

@techplusintl

Hi there, ★★★ Google Apps Script / Sheets / Forms / VBA Expert ★★★ 8+ Years of Experience ★★★ I've read requirements and ready to fix issue with Google AppScript. I am capable of developing both script-based and formula-based spreadsheets, as well as anything related to Google Services, Integration, and Automation. My Services: ✔️ Google sheets automation ✔️ Google Form, Google Docs, Apps ✔️ Google apps script ✔️ Automate google calendar ✔️ Creating bulk google calendar events from google sheet ✔️ Auto-generate reports from google sheets ✔️ Gmail automation (Auto send or delete emails from Gmail) ✔️ Integration of all Google services (spreadsheets, calendar, maps, Gmail, etc.) and other third-party APIs ✔️ Dashboard design and automation ✔️ Formulas, Fix your data, Filters, Queries ✔️ Conditional formatting, Crush Duplicates ✔️ REGEX, Countif, VLookup, Hlookup, Index Match ✔️ Interlinking Sheets or other Google sheets sheets ✔️ Importing Data from Websites and other Google Sheets ✔️ Manage Drive From Sheet ✔️ Pivot charts, Pivot Tables, Dashboards As the requirements on project are not complete and need discussion so i placed tentative bid. To provide you the best quote, let's have a chat! Best Regards, TechPlus Team

$250 USD in 2 days

4.7

(3 reviews)

3.2

@ajeshjanardanan

Hi Jason B., How are you doing? As a professional developer with expertise in Google Sheets, Google Apps Scripts and Google Docs, I eagerly anticipate the opportunity to complete this project for you. Please drop me a message to discuss the project detail. Thank you for considering my services.

$50 USD in 4 days

0.0

(0 reviews)

0.0

@asifmahmudpro

Hi there, How are you? I am a software engineer. Let's do this right now. I know Google Apps Scripts very well. I have a strong background in scripts. I appreciate the opportunity to assist you with Google Apps scripts. I can complete the project with very high quality and accuracy. I will need some more details about the project. So, I will wait to hear from you. I will appreciate it if you give me the project. It will be very helpful for me. Thanks.

$30 USD in 1 day

0.0

(0 reviews)

0.0

@akapar

From brief description I can propose 2 potential solutions: 1) The script will be modified to track time. It will be manually stopped before 6 minutes and the progress parameters will be saved (e.g. in Google Properties Service or Cache). Then the script will automatically be resumed using Trigger functionality (e.g. pause script after 5 minutes, save progress, resume script until job is complete) 2) Your current script may contain some inefficiencies that makes it impossible to complete within 6 minutes. In that case the inefficiency will need to be fixed.

$280 USD in 7 days