Apps scripts timing out randomly

[Geoffrey Quick]

I have two apps scripts which read data from a google spreadsheet and send it by email to an email address.   

emailJobDetails sends job details to a user entered email address

after the user enters a job number which extracts the job data from

a particular column in a spreadsheeet.

emailJobDetails_1 sends job details to two email addresses extracted

from the spreadsheetm after the user enters a job number which extracts the job data from

a particular column in a spreadsheeet.

Most times the scripts run fine within 6 minutes execution but sometimes

they time out at 6 minutes and no message is given to the user

that the job has failed.

Please advise how these apps script could be improved to execute faster,

or how they could be split into smaller apps that avoid the

6 minute execution time limit

both apps scripts attached and a specimen column from the spreadsheet.

Thanks in advance

Geoff

[Geoffrey Quick]

Hi there,

I've had no suggestions as to how to make my scripts more efficient so that they run without randomly timing out.  Any suggestions where I can go for help please ?

[DimuDesigns]

A few tips. 

• Copy/Paste your scripts into the body of your messages or put them in a GIST (see https://gist.github.com/) and link to them.
• Read the GAS documentation/guides for best practices (see https://developers.google.com/apps-script/guides/support/best-practices)