Track weekly Web3 funding rounds in a spreadsheet

Compiles the past week's Web3 and crypto funding rounds into a spreadsheet with amounts and investors.

How the work actually flows

A straight line. Runs once per each funding round found.

Pattern: Sequence (1) ยท Multiple Instances without a priori Run-Time Knowledge (15)

flowchart TD trig(["weekly funding research schedule"]):::trigtime s0[["Extract details for each round"]]:::mi s1[("Save records to spreadsheet")]:::store trig --> s0 s0 --> s1 out[/"Weekly Web3 funding spreadsheet"/]:::out pay{{"Stay current on funding landscape"}}:::pay s1 --> out out --> pay classDef task fill:#e7f6fe,stroke:#34b8f0,color:#2c2a29 classDef svc fill:#f6f8fa,stroke:#7c8795,color:#2c2a29 classDef mi fill:#e7f6fe,stroke:#0079a8,color:#2c2a29,stroke-width:2px classDef human fill:#fff,stroke:#0079a8,color:#0079a8 classDef store fill:#f6f8fa,stroke:#0079a8,color:#2c2a29 classDef trig fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigtime fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigdata fill:#8ad4f5,stroke:#0079a8,color:#06314c,font-weight:bold classDef gate fill:#fff,stroke:#e8a23d,color:#6b4708,font-weight:bold classDef out fill:#1f9d6b,stroke:#167a53,color:#fff,font-weight:bold classDef pay fill:#06314c,stroke:#021f33,color:#fff
Starts itRuns once per itemA record or sheetResultPayoff
Build size
Starter

A small build with a couple of connected tools.

Business functions
Reporting & Analytics
Connects
Google Sheets

The problem it solves

Keeping up with who raised what in crypto means checking a dozen sources every week. By the time you compile it yourself, the information is already stale.

Who it fits

A venture investor, analyst, or founder tracking the Web3 funding landscape.

How it works

  1. Runs on a weekly schedule
  2. Searches for Web3 and crypto funding announcements from the past week
  3. Extracts amounts, investors, categories, and descriptions for each round
  4. Saves the records to a spreadsheet
What you get

Funding rounds tracked without searching

You get a running spreadsheet of the week's Web3 and crypto funding rounds with amounts and investors filled in.

What you get

A weekly spreadsheet listing funding rounds with amounts, lead investors, and categories.

What you need

A Google Workspace account and access to news or funding data sources.

We can build this. But should you?

The hard question is not how to build it. It is whether this is the right thing to build first.

That is what a Fractional Chief AI Officer figures out with you, before anyone writes a line of code.

Let's Talk Strategy

Related automations

Run A/B tested email campaigns tracked in Google Sheets

Sends A/B tested email campaigns from Gmail, tracks results in Google Sheets, and reports progress in Slack.

Advanced

Send calendar reminders by email and text automatically

Turns Google Calendar into an automatic reminder system with daily emails, text alerts, and a live dashboard.

Advanced

Log domain authority and SEO scores to a spreadsheet automatically

Submit a website through a simple form and get its domain authority, spam score, and traffic logged to a spreadsheet.

Standard

Send a daily WooCommerce sales summary to Slack and Google Sheets

Each day it pulls your WooCommerce orders, calculates revenue and top sellers, and posts the numbers to Slack and Sheets.

Advanced
Back to the AI Playbook