How it runs: Scheduled. An automation runs on day 5 of each quarter, posts the draft and saves the letter and metrics table. You can also ask Hops any time.
What it does
- Collects the numbers. Hops reads founder updates in Gmail and portfolio metrics in Google Sheets.
- Builds the portfolio table. One row per company with ARR, growth and runway.
- Drafts the letter. Fund highlights, company notes and risks, matching last quarter’s tone and format.
- Flags risks. Companies with short runway or missed plans are called out with a note.
- Lists who is missing. Companies that have not sent an update are listed so you can chase them.
Ask Hops
Copy a prompt into any chat with Hops, or mention@Hops in a Space.
Q3 LP update drafted:
- Portfolio ARR up 31% year over year.
- Brightpath runway under 12 months; plan noted.
- Letter and metrics table ready for review.
What you get
- A post in the portfolio Space (or Slack channel) when the draft is ready.
- A dated Doc in Docs with the LP letter and a metrics Table in Tables with every company.
- Answers on demand. Ask Hops for any metric or company in chat.
Connections needed
Connect these apps. Each card opens Connections in the app.Gmail
Founder updates.
Google Sheets
Portfolio metrics.
Slack
Where the draft post goes.
Set it up
1
Connect your apps
Connect the apps above in Connections.See Connections.
2
Create the Space
Create a portfolio Space and pin last quarter’s LP letter in Space context.See Spaces and Space context.
3
Add the skill
4
Schedule it
Run it on day 5 of each quarter. It posts the draft to the portfolio Space and saves the letter Doc and metrics Table.See Automation.