𝗚𝗼𝗼𝗴𝗹𝗲 𝗦𝗵𝗲𝗲𝘁𝘀 𝗘𝗺𝗮𝗶𝗹 𝗮𝗻𝗱 𝗥𝗲𝗺𝗶𝗻𝗱𝗲𝗿 𝗠𝗮𝗻𝗮𝗴𝗲𝗺𝗲𝗻𝘁 𝗧𝗼𝗼𝗹

Hello Everyone,

A great welcome to you all! Today, we're excited to introduce a powerful tool built in Google Sheets using App Script to manage your emails and reminders efficiently. This unique tool allows you to send emails and reminders directly from your Google Sheet. It's a better alternative for several reasons:

- 𝐂𝐨𝐥𝐥𝐚𝐛𝐨𝐫𝐚𝐭𝐢𝐯𝐞:  Your team can work together on the same file without missing any updates.
- 𝐂𝐨𝐧𝐯𝐞𝐧𝐢𝐞𝐧𝐭:  No need to stay on the application for tasks to complete.
- 𝐔𝐬𝐞𝐫-𝐟𝐫𝐢𝐞𝐧𝐝𝐥𝐲:  Easy to share and navigate.
- 𝐀𝐭𝐭𝐚𝐜𝐡𝐦𝐞𝐧𝐭-𝐟𝐫𝐢𝐞𝐧𝐝𝐥𝐲:  Easily attach files by pasting the link.

You can use this tool for various purposes such as 𝐜𝐥𝐢𝐞𝐧𝐭 𝐨𝐧𝐛𝐨𝐚𝐫𝐝𝐢𝐧𝐠, 𝐜𝐥𝐢𝐞𝐧𝐭 𝐨𝐧𝐛𝐨𝐚𝐫𝐝𝐢𝐧𝐠, 𝐮𝐩𝐝𝐚𝐭𝐞𝐬 𝐭𝐨 𝐞𝐱𝐢𝐬𝐭𝐢𝐧𝐠 𝐜𝐥𝐢𝐞𝐧𝐭𝐬, 𝐜𝐨𝐥𝐝 𝐞𝐦𝐚𝐢𝐥𝐢𝐧𝐠, 𝐫𝐞𝐦𝐢𝐧𝐝𝐞𝐫𝐬, and more.

Let's get started with a quick tour:

𝟏. 𝐂𝐮𝐬𝐭𝐨𝐦𝐞𝐫 𝐒𝐚𝐥𝐞𝐬 𝐒𝐡𝐞𝐞𝐭
This sheet is designed to keep track of all your client details. Here’s what you can do:

-  Enter Client Details:  Name, email address, stage of interaction, fees quoted, etc.
-  Attach Files:  Just paste the link in the cell to attach files to emails.
-  Generate Auto Subjects and Messages:  Fill in the details and click on the send mail button.
-  Send Emails:  Two buttons are provided – one for sending emails through mail addresses and another for sending messages through labels, allowing you to send emails to large groups without needing individual email IDs.

𝟐. 𝐃𝐮𝐞 𝐃𝐚𝐭𝐞 𝐌𝐚𝐧𝐚𝐠𝐞𝐦𝐞𝐧𝐭 𝐒𝐡𝐞𝐞𝐭
This is the core of our system where you manage all deadlines and reminders. Features include:

-  Set Due Dates and Reminders:  For each client, you can set a due date and up to three reminders.
-  Automated Email Sending:  Our AppScript automatically sends out emails on the specified dates.
-  Completion Tracking:  The cells highlight once emails are sent, so you can easily track completed tasks.
-  Send Options:  You can send emails via mail IDs or labels.

𝟑. 𝐄𝐦𝐚𝐢𝐥 𝐋𝐨𝐠 𝐒𝐡𝐞𝐞𝐭
This sheet maintains a comprehensive history of all your email communications. It logs:

-  Timestamp:  When the email was sent.
-  Recipient:  Email address or label.
-  Subject and Message:  Content of the email.
-  Status and Attachments:  Status of the email and any attached file links.

𝟒. 𝐃𝐚𝐬𝐡𝐛𝐨𝐚𝐫𝐝
The dashboard offers a quick overview of your key metrics. It includes:

-  Reminders Sent:  Total number of reminders sent.
-  Upcoming Reminders:  Alerts for future reminders.
-  Total Recipients:  Number of recipients.
-  Email Activity:  Number of emails sent today or yesterday.
-  Upcoming Events:  Helps you stay on top of your schedule.

By using this tool, you streamline your email and reminder management processes, ensuring efficiency and accuracy in your client communications.

📞6202490512

📥divyandev365@gmail.com

Demo Video :- https://youtu.be/SVCM_o8Zgfw?si=edcE04LKeJF4wJvk