Weekly crypto newsletter, drafted in Gmail every Friday

Every Friday at 2pm ET, draft my weekly crypto market newsletter as a Gmail draft I can review and send to my subscriber list. Build this as an agent workflow on a cron trigger.

When it runs, the agent should do the following:

1) Pull this week's market context from Crypto Data: use Get Markets Overview for the top ranked coins with 7-day price change, Get Trending Coins for what people are searching right now, Get Market Chart (vsCurrency=usd, days=7) for each coin in my watchlist, and Get Coin Info for any coin that becomes the story of the week so the newsletter has color and links.

2) Pull the week's most relevant crypto headlines from NewsAPI using Search Everything, scoped to the last 7 days with queries like "bitcoin OR ethereum OR crypto OR stablecoin OR SEC crypto OR ETF" and sortBy=relevancy. Pick the 5 to 8 articles that matter most for an investor reading on a Friday afternoon. Dedupe near-duplicate stories.

3) Synthesize a clean, opinionated but neutral newsletter with these sections, in this order:

- What moved this week: 3 to 5 bullets on the biggest movers (anything >5% up or down from the watchlist plus the broader top list), each tying the move to a likely catalyst from the news.

- Story of the week: one short narrative paragraph on the single biggest theme (ETF flows, regulation, a token launch, a hack, a macro print).

- Trending right now: a short 3-bullet callout of the trending coins, with a one-line note on whether the 7-day chart agrees with the chatter or contradicts it.

- Watching next week: exactly 3 bullets on upcoming catalysts (FOMC, token unlocks, congressional hearings, large earnings prints, conference dates).

- Short sign-off with a one-line disclaimer: "This is not financial advice."

4) Save the formatted HTML to my Gmail as a draft using Create a Draft. The draft should be addressed To: me, with my subscriber list on Bcc, and a subject line in the format "[Crypto Weekly] {short headline} – {date}". The body should be valid HTML with simple inline styling so it renders cleanly in Gmail: a header, paragraphs, bulleted lists, and bolded subsection titles. Do not send the email. Leave it as a draft so I can edit the voice and hit send myself.

Voice and constraints: neutral, analyst-style; never financial advice; never tell the reader to buy or sell; write "X gained 12% this week as Y", not "buy X". No em dashes anywhere in the newsletter body. Keep the whole thing readable in about 3 minutes.

Skip rule: if no watchlist coin moved more than 5% in either direction this week AND there are no notable crypto headlines (no major regulatory action, ETF flow, macro print, hack, or major launch), do NOT create a draft. Log a one-line message that the week was genuinely flat so I do not send filler.

Inputs I will set on the workflow: my coin watchlist as CoinGecko coin IDs (for example: bitcoin, ethereum, solana, then edit to taste), the Bcc address for my subscriber list, and the subject prefix "[Crypto Weekly]".

Additional information

What does this prompt do?

Pulls the week's market overview, your watchlist's 7-day price moves, and the coins trending right now.
Combines that with the week's most relevant crypto headlines so each move has a story behind it.
Writes a clean, analyst-style newsletter with sections for the biggest moves, the story of the week, a short outlook, and a trending callout.
Saves the finished email as a Gmail draft addressed to your subscriber list so you can polish the voice and hit send.
Skips the week entirely if nothing actually moved, so you never send filler.

What do I need to use this?

A Gmail account connected to General Input with permission to create drafts.
A NewsAPI key. The free Developer plan is enough for a personal weekly newsletter.
Your subscriber list (or a Google Group address) to use as the Bcc on each draft.
A short watchlist of coins you want covered each week. Market data itself is included, no separate account needed.

How can I customize it?

Change the cadence or send time, for example a daily morning brief or a Sunday evening recap instead of Friday at 2pm.
Swap the coin watchlist or narrow the angle to a theme like AI tokens, layer-2s, stablecoins, or memecoins.
Adjust the tone and structure, for example a more opinionated take, a longer outlook, or an added long-reads section.
Tighten or loosen the skip rule so the newsletter only goes out on bigger weeks, or runs every week no matter what.

Frequently asked questions

Does this send the email automatically?

No. It saves the newsletter as a draft in your Gmail so you can review, tweak the voice, fix anything that reads off, and then hit send yourself.

Can I use a different subscriber list?

Yes. Edit the Bcc list inside the workflow, or point it at a Google Group address you manage separately so you can add and remove subscribers without touching the workflow.

What if nothing happened in crypto that week?

The agent checks for meaningful price moves and headlines first. If the week was genuinely flat, with no coin moving more than 5% and no notable news, it skips the draft entirely so you never send filler.

Will this give my readers financial advice?

No. The tone is set to neutral and analyst-style. It summarizes what happened and what to watch, never tells readers to buy or sell, and includes a short disclaimer at the bottom.

Do I need a paid NewsAPI plan?

Not for a personal weekly newsletter. The free Developer plan delays articles by up to 24 hours, which is fine for a Friday roundup. Upgrade only if you want a live daily brief.