Weekly segment export to a sheet
Writes a segment into a Google Sheet every week, replacing the CSV someone downloads and re-uploads by hand.
Curated by Trishik Shrestha
Growth Marketer at Intempt
About this recipe
When to use it
Someone exports a CSV, opens it, pastes it into the shared sheet, then does it again next Monday. This writes the segment into the sheet directly.
What it delivers
Picks the audience to export, then refreshes a Google Sheet with its members every week.
recipe.md preview
Built from the published catalog. Blu's full step prompts load in your workspace when you run it.
---
id: google-sheets-segment-weekly-export
title: "Weekly segment export to a sheet"
slashCommand: /google-sheets-segment-weekly-export
group: Workflows
curator: "Trishik Shrestha"
classification:
product: [marketing]
mode: [all]
complexity: starter
procedure:
- step: 1
title: "Pick the audience to export"
builds: segment
produces: segment
- step: 2
title: "Refresh the sheet each week"
builds: workflow
produces: workflow
outputs:
- segment: segment
- workflow: workflow
---
# Weekly segment export to a sheet
Writes a segment into a Google Sheet every week, replacing the CSV someone downloads and re-uploads by hand.Inputs & outputs
What the recipe needs before it runs, and what it leaves in your workspace.
Inputs
- 01Integration: google_sheetsRequired
Outputs
- 01SegmentSegment produced by this recipe.
- 02WorkflowWorkflow produced by this recipe.
How the recipe runs
Blu follows the steps in order and shows you each one before anything goes live.
- 01Pick the audience to exportDefine it as a segment rather than a filter inside the workflow, so the same definition drives the export and anything else that needs the same list.Segment
- 02Refresh the sheet each weekA weekly run writes the segment's members into the sheet, matched on the record identifier so a repeat run updates rows instead of duplicating them. The row count is stated before the run, so a segment that has collapsed or exploded is visible.Workflow
Connections required
- google_sheetsRequired
Install Intempt and run it
- 1
Sign up
Create a free Intempt workspace.
- 2
Connect your data
Add the sources this recipe reads from.
- 3
Ask Blu
Type /google-sheets-segment-weekly-export in Blu once this recipe is live there.
- 4
Review and approve
Blu builds each step and waits for your OK before anything goes live.
Related recipes
Trishik ShresthaAI account researchReads a target account's website, pulls out the decision makers, scores the fit against your ICP, and drafts an opener for the rep to edit.View recipe Trishik ShresthaHuman approval for AI actionsHolds the riskier things an AI workflow wants to do, such as a mass update or a send to a big account, for a yes or no in Slack.View recipe Trishik ShresthaAI drafted sales repliesDrafts a reply to every inbound sales email using the thread, the deal stage and the buyer's recent product use, and leaves it in the rep's drafts.View recipe 