Icon

How to Collate Weekly Updates into a Single Document

If you've ever wished you could collect and collate periodic emails into a single scrollable document, you're in luck.

By Kristi Lim

In this guide, we'll learn how to set up an automation using Zapier to manage emails efficiently. We'll create a trigger for new emails matching a specific search, connect our account, and decide where to store the information. Options include creating or updating a page in Notion or appending text to a Google Docs document. This process helps streamline email management and ensures important information is organized and accessible.

Let's get started

First, go to zapier.com to set up your automation. You'll find yourself on a page that looks like this. Under Trigger, search for "Gmail" and click on the event "New Email Matching Search."

1
Click here
Step #1: Click here
2
Click here
Step #2: Click here

You need to connect your Email account. Then, you'll be directed to type in a relevant search string.

3
Click here
Step #3: Click here
4
For our example, I am typing: "weekly update superacme".

If you find a suitable record, proceed with it. You can then save it wherever it makes sense, such as in Notion.

You can create or update a page.

5
Step #5:
6
Step #6:
7
Step #7:
8
Step #8:
9
Step #9:

Alternatively, you could use Google Docs. You might also append text to a document. The text to append will be the plain body. You can also add additional content.

10
Step #10:
11
Step #11:
12
Step #12:
13
Click here
Step #13: Click here
14
Click here
Step #14: Click here

And there you have it! As a bonus: You can also add in a "ChatGPT" step if you would prefer these digests be summarized or processed before getting compiled into your document.

15
To do that, you would click in between our two existing steps, and then select "ChatGPT". Click "Create Conversation", and then add "Body Plain" onto a relevant prompt.
Step #15: To do that, you would click in between our two existing steps, and then select "ChatGPT". Click "Create Conversation", and then add "Body Plain" onto a relevant prompt.