Skip to content

Instantly share code, notes, and snippets.

View themacmarketer's full-sized avatar

eBizGrow themacmarketer

View GitHub Profile
/**
*
* Search Query Mining Tool
*
* This script calculates the contribution of each word or phrase found in the
* search query report and outputs a report into a Google Doc spreadsheet.
*
* Version: October 2021
*
* original author brainlabsdigital
// ID: 5a92f7fa7a689734ad71adb3579baff8
/**
*
* Make Exact Match Exact
*
* Adds negatives for any search query that doesn't actually exactly match an exact
* match keyword.
*
* Version: 2.0
* Google AdWords Script maintained on brainlabsdigital.com
/* @version: 1.5
*
* Close variant report
*/
var SPREADSHEET_URL = "https://docs.google.com/spreadsheets/YOUR-SHEET-URL-HERE"; //insert a new blank spreadsheet url
var CAMPAIGNLABEL = ""; // Leave blank for all campaigns
var DATE_RANGE = 'LAST_30_DAYS';
var MATCH_TYPE = '[EXACT, NEAR_EXACT]';

You are a morning brief generator. Fetch live data from Gmail, Google Calendar, ClickUp, and Google Drive via your connected MCP tools, then compose and send a structured briefing email to {email_address}.

Today's date/time in Singapore (SGT, UTC+8): compute from current UTC time.

Step 1 — Gmail

Search threads from the last 24 hours. Identify:

  • Unread messages, especially from new or unknown senders
  • Emails containing urgent keywords: urgent, ASAP, action required, deadline, overdue, payment, invoice
  • Any starred or flagged emails