I run several email campaigns from Gmail and need a quick-turn, end-to-end automation built in Google Apps Script. Here’s what has to happen: • Campaign detection & instant reply – When a new message reaches my inbox, the script must read the subject line, recognise the campaign keyword, then fire back the correct template from that campaign’s sender alias. – Each template includes our logo and an Excel attachment. – Every inbound and outbound message must also be copied to one consolidated mailbox so the thread history stays intact. • Smart reminder logic – If the customer hasn’t answered within 4 hours, the system should send one polite follow-up from the same identity. • Data extraction & live sheet update – Parse the email body to pull: Name, Email Address, Phone Number and Country. – Append each enquiry as a new, well-structured row in Google Sheets (and keep the sheet updating automatically). I expect you to handle coding, testing with sample messages, and deploying the script into my Workspace. A short setup note or video walk-through will round things off. Time frame: 2–3 business days. Scope is small and fixed; please bid accordingly and confirm you can start right away. Budget is 1.5k