Automation Process of onboarding artists for a music festival using Google sheet app scripts.
I am looking to hire someone to help complete the app script ( OR START FROM SCRATCH) and create a Google sheet script to accomplish the steps below.
The current script is linked to the description video, google folder, and Google sheet below. What I am looking to do is described below in detail.
Thanks for looking! This is a small job however, if it works well, I’ll be doing several more like it.
T
Automation Process of onboarding artists for a music festival.
1. Create Offer Sheet
* Generate a Google Doc “Offer Sheet” from data in the Google Sheet using a provided template.
* Insert a link to the newly created “Offer Sheet” in the adjacent column of the Google Sheet.
2. Email Drafting and Sending
* Draft an email in Gmail using a template and attach a PDF of the “Offer Sheet.”
* Auto-populate the “Email To” field.
* Auto-populate the “Email Subject” field.
* Track email status:
* Record when the email is sent.
* Monitor if the email is received and opened.
3. Automation of Contracts
* Automate contract creation similar to offer sheets.
* Send contracts for electronic signature via Adobe Sign or a similar service.
4. Google Forms Automation
* Create unique Google Forms for each artist.
* Draft email templates with instructions and links to each artist’s form.
* Auto-populate the “Email To” field.
* Auto-populate the “Email Subject” field.
* Send forms to artists and set reminders for incomplete forms.
* Compile all form data into a master check-in spreadsheet.
* Generate printout templates for each guest with credentials and details collected via forms.
5. CRM Integration
* Collect all content added to documents via forms or manual input into a simple CRM for future access.
This flowchart outlines the process from creating offer sheets to integrating data into a CRM, providing a clear path for automating your workflows using Google Sheets and App Scripts.
LINK TO VIDEO DESCRIPTION – STEP 1
https://drive.google.com/file/d/1rR5Qt6yZ6Spz1yuAsJ87-tS0ozEnT8dm/view?usp=sharing
LINK TO GOOGLE SHEET – Vew only https://docs.google.com/spreadsheets/d/1yuPZDZVvXJEk3EtY9otc56wStAK1saz2jgLsTKInJ8M/edit?usp=sharing
LINK TO GOOGLE FOLDER
With Talent Offers Template and Offer Sheets Incoming Folder
https://drive.google.com/drive/folders/1yVuFFUPZGiM8txOpHPLfBZxoCZyQ2NAx?usp=sharing
STEP 1 – CURRENT APP SCRIPT ATTACHED
Start
|
v
Create Offer Sheet
|
v
+————————-+
| Generate Google Doc |
| “Offer Sheet” from data |
+————————-+
|
v
Insert Link in Sheet
|
v
Draft Email in Gmail
|
v
+————————-+
| Attach PDF of “Offer |
| Sheet” |
+————————-+
|
v
Auto-populate Email & Subject Fields
|
v
Send Email
|
v
Track Email Status
|
v
+————————-+
| Record Sent Status |
| Monitor Open Status |
+————————-+
|
v
Automate Contracts (Step 2)
|
v
+————————-+
| Create Contracts |
| Send for E-signature |
+————————-+
|
v
Google Forms Automation (Step 3)
|
v
+————————-+
| Create Forms for Artists|
| Draft Email with Form |
| Links |
+————————-+
|
v
Send Forms & Set Reminders
|
v
Compile Form Data in Master Sheet
|
v
Generate Printout Templates
|
v
CRM Integration (Step 4)
|
v
+————————-+
| Collect and Store Data in|
| CRM for Future Use |
+————————-+
|
v
End
