I have four scripts that work in Google Sheets but they take too long to run and time out. The specific message generated:
Exceeded maximum execution time in Google Apps Script
I’d like these scripts re-written in Python. On certain phrases, data is copied and pasted from one tab to another.
On the spreadsheet below, in column I, there appear four phrases Enter Long, Close Long, Enter Short, Close Short. I need script that keys off those entries -- for instance when it encounters "Enter Long" in a particular column, it copies four cells, moves to the next TAB, pastes the copied cells there, then highlights the row or changes the font color so I can easily find all changes. There are four such commands or actions required.
If you respond, please include “write four Google Sheets scripts in Python” so I know you’ve read this. Please estimate time involved.
The view-only link to the sheet I need help with:
[login to view URL]
See Project Notes Tab.
Please respond if:
• have an excellent rating on this platform or can provide client references
• are available to discuss the project and are fluent, easy to understand in English.
• are available to work at least some Eastcoast US business hours
My website [login to view URL]
35 freelancers are bidding on average $22/hour for this job
Dear Sir. As a talented python expert,I can say no problem. Please visit my reviews. Then you can check my skills. I can give you awesome result. Please contact me. Thank you.
Hi I am very interested in your project. I have rich experiences in Goolge Sheet API using Java and Python I can work by your suggestion Please contact me and let's start right now. Thank you