Google Scripts to Communicate Between 1-3 Google Spreadsheets and Gmail

Google Scripts to Communicate Between 1-3 Google Spreadsheets and Gmail

Closed - This job posting has been filled.

Job Description

We need google scripts written in our google spreadsheet templates.

We have two sheets and each have multiple tabs.

We would like a button in sheet 1 that generates a copy of a template sheet 2 and also communicate adds data to certain cells in sheet 1.

There will also be approximately 7 more buttons that send specified data and instructions to cells in sheets 1 and 2.

A few of the buttons will generate generic emails to our account.

Examples of communication between sheets will be:

"Button 1" adds "n" to cell A8, add timestamp to cell B8,sends contents of cell C8 and D8 to cell G11 and H11 of "sheet 2" - "tab 2."


Detailed build instructions will be provided.

You must be familiar with google script writing.