⚡Workspace Automation Blueprints

Automate Your Work

Repetitive tasks consume time. Explore practical automation workflows that connect Google Workspace tools and reduce manual work using free, zero-maintenance Google Apps Script code.

Email Parsing⏱️ 5 mins

Gmail → Google Sheets

Automatically collect selected email information into a spreadsheet.

Lead Notification⏱️ 10 mins

Forms → Sheets → Gmail

Collect form submissions, process the data and automatically send notifications.

Mail Merge⏱️ 8 mins

Sheets → Gmail

Send personalized emails using spreadsheet data.

Reminders & Sync⏱️ 12 mins

Calendar → Gmail

Automate event reminders and follow-up messages.

File Indexing⏱️ 6 mins

Drive → Sheets

Track files and documents automatically.

Document Export⏱️ 15 mins

Sheets → PDF

Generate structured PDF documents from spreadsheet data.

Active Blueprint

Gmail → Google Sheets

Use Case: Extract incoming lead emails, customer orders, or payment confirmations into a central Google Sheet without copy-pasting.

Trigger: Time-driven Trigger (Every 10 minutes) or Gmail Search Query
Difficulty: Beginner
Code.gs — Google Apps Script
function saveLeadsFromGmail() {
  const query = 'label:leads is:unread';
  const threads = GmailApp.search(query, 0, 10);
  const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Leads');
  
  threads.forEach(thread => {
    const messages = thread.getMessages();
    messages.forEach(msg => {
      if (msg.isUnread()) {
        const date = msg.getDate();
        const from = msg.getFrom();
        const subject = msg.getSubject();
        const bodySnippet = msg.getPlainBody().substring(0, 300);
        
        sheet.appendRow([date, from, subject, bodySnippet]);
        msg.markRead();
      }
    });
  });
}

How to Deploy This Script:

  1. Open your target Google Sheet or document where you want this workflow to run.
  2. Click Extensions > Apps Script in the top navigation bar.
  3. Paste the code snippet above into the Code.gs file editor.
  4. Replace any placeholder IDs (e.g. YOUR_GOOGLE_DRIVE_FOLDER_ID) with your actual assets.
  5. Save the project (Ctrl + S), select the function, and click Run.
  6. To set automated scheduling, click Triggers (alarm clock icon on left sidebar) > Add Trigger.