Saturday, May 14, 2022
HomeWebsite DesignCreate A Brag Doc with Zapier and Google Sheets

Create A Brag Doc with Zapier and Google Sheets

On this article, we’ll arrange a way the place you may obtain a every day electronic mail with questions so that you can reply. These questions may be distinctive to your self or be arrange with inspiration from a brag doc and a every day evaluate. These will aid you bear in mind the issues that you simply’ve achieved all through the day and to research the way you’ve felt and what occurred to make you are feeling that manner.

What Is a Brag Doc?

Our mind isn’t the very best instrument for remembering issues except you’re blessed with a photographic reminiscence. Yow will discover your self not remembering stuff you’ve achieved within the final week or month.

A brag doc is the ace up your sleeve with regards to sitting in entrance of your supervisor for a evaluate. Most of us work roughly about 2000 hours a yr. How a lot of what you do, do you suppose your supervisor is conscious of?

There might be stuff you’re engaged on which might be making massive adjustments within the enterprise, however they by no means get introduced up together with your supervisor. It’s these little issues that get passed over and never thought of with regards to evaluate time.

That is the place a brag doc is available in. To avoid wasting you from having to make use of your not-so-good reminiscence, why not obtain an electronic mail day by day that asks you what you’ve accomplished. This info is then saved in a Google sheet so you’ve gotten full information, from the smallest to the biggest stuff you’ve managed to realize at work.

Then, when it comes right down to your yearly evaluate, you may simply present all of the stuff you’ve achieved, which might provide the leverage you must get that well-deserved pay rise. 😃

What Is Self Reviewing?

You’re trying to improve your automobile. You’ve had a motor for a few years nevertheless it’s on its final legs, spurting black smoke and making clunking noises whenever you drive.

You’ve spent a while doing analysis to ensure you’re shopping for the best automobile. After an extended debate, you choose a BMW. And as if out of nowhere, you see the identical make and mannequin in every single place, though weeks in the past none of them had been on the street.

That is known as the Baader-Meinhof Phenomenon. It’s when one thing has been delivered to your consciousness and it seems to be in every single place. That is the impact that we’ll be attempting to benefit from together with your self reviewing.

When you ask your self “What unhealthy behavior did I partake in at this time?”, it’ll make you concentrate on something you contemplate a foul behavior, like consuming a complete pack of cookies or doom-scrolling on social media.

If we now do that for over every week, the Baader-Meinhof Phenomenon begins to happen. You now grow to be extra acutely aware about these behaviors. Quite than this habits occurring with out considering, you’ll have the ability to spot when it occurs since you’ve been writing about it day by day. After which you can also make an effort to cease that habits.

Self reviewing also can aid you to research how your day went. Once more, we now have some questions that immediate us, corresponding to “What did I take pleasure in doing?” or “What sucked the power out of me?”

These are questions that may aid you spot patterns after which take motion. When you discover that you simply take pleasure in writing, then you may plan to do extra. When you discover that speaking to a sure somebody at work drains all of your power, you may attempt to converse to them as little as potential, or decide occasions of the day when you’ve gotten sufficient power to take care of them.

With little or no effort every day, you can begin to gather necessary info, from the superior work you’ve been doing, to the habits which might be invisible to you, after which make plans every week to enhance your life.

Easy methods to Set Up Your Every day Emails

There are three issues that we want to have the ability to arrange every day emails:

  • a Zapier account
  • a Google Drive account
  • a set of questions

The Zapier account will deal with the automation: the sending of the questions, and the parsing of the information from the e-mail.

The Google Drive account is for establishing the Google Sheets the place the information from electronic mail can be saved for reviewing our solutions.

The set of questions would be the info we need to collect.

Earlier than we start, we have to arrange an account on Zapier and be sure that we now have a Google Drive account.

As soon as we’ve achieved that, we are able to get began.

Sending Every day Emails

To get issues began, we have to ship ourselves an electronic mail so we now have a immediate to reply the questions.

To try this, we have to arrange a zap in Zapier.

From the Zapier house web page, click on on the menu navigation and choose Zaps.

Brag document zaps

Click on on Make A New Zap.

making a brag document new zap

The Zap we’re establishing is to ship every day emails. We’ll arrange one other Zap to parse the information into the Google Sheets.

On the prime of the display screen, we are able to identify our zap. Let’s identify it Sending every day emails.

Sending daily brag document emails

First, we choose a set off. Seek for Schedule by Zapier.

setting a schedule

We then want to pick the frequency of the set off. We might make this every day, weekly, or month-to-month. On this event, we’re choosing every day.

brag document daily

Subsequent, we are able to select if we would like the e-mail to be despatched on the weekends and what time of the day we need to obtain the e-mail.

If we’re setting this up with our work electronic mail, it could be value turning it off for weekends if we don’t work then. It’s finest if we set the time for the top of the day, so all of the occasions of the day are over and we now have sufficient time to reply the questions. Setting it an hour earlier than we go away is an effective choice.
It’s going to ask us to check the set off. As soon as achieved, proceed.

setting up the brag document trigger

The motion we need to occur with the above set off is to ship the e-mail with our questions. We will do that by choosing E mail by Zapier.


As soon as chosen, we need to select the motion kind as outbound electronic mail.


Subsequent, we enter the e-mail tackle we need to obtain the questions at, the topic line, and the physique of the e-mail (which can be our questions). We’ll additionally have to enter an electronic mail tackle within the “Reply-To” area, however we’ll try this later.

Just remember to go away area between every query so your solutions can get parsed. You need three line breaks value of area. At this level, we would like a duplicate of the physique of the e-mail, so paste it to a Phrase doc or textual content word, as we’ll be utilizing that later. The remainder of the fields we are able to go away clean.

setting up the action

The ultimate step is to ship a check electronic mail simply to be sure that we obtain the e-mail.

sending a brag document test email

We now have a every day electronic mail arrange. The following step can be to parse the information from the e-mail right into a Google Sheet.

First, we log in to our Google Drive account. Subsequent, we create a Google sheet. We will identify it no matter we like. On this occasion, we’ve named it Every day Recap.

As soon as we now have our Google sheet, we have to add some column names. Within the first column, we’re going to trace the date. The columns subsequent to that ought to have our query, because it’ll make it straightforward for us to see what reply equates to which questions.

setting up columns

With the Google sheet prepared, we now have to parse the information from our replies and have them entered into the proper cells.

Head again to Zapier and create a brand new zap.

a new zap

If prompted, choose “Create a customized zap”. This zap we’ll identify Parse Knowledge. The set off that we would like is E mail parser by Zapier.

parse email

A set off occasion is required for this motion, so we need to choose “New electronic mail”. This may set off each time we ship a response again to the every day electronic mail.

new email

Subsequent, we have to check in to the E mail Parser. All we want is our Zapier account particulars to log in. If we haven’t already, it should ask us to attach E mail Parser to our Zapier account by clicking authorize. As soon as that’s achieved, click on proceed.

To have the ability to arrange the set off, we have to create a mailbox.

Click on Create Mailbox.

creating a mailbox

After we’ve created our inbox, we have to create our template to parse our brag doc solutions from. We retrieve the physique of the every day emails that we copied earlier right into a Phrase or textual content word and paste it into the preliminary template.

Subsequent, we have to choose the areas the place we need to parse the information. This may be achieved by creating tags. That is achieved within the following manner: {{TAG_NAME}}.

The TAG_NAME must be changed with a novel identify, so the questions are parsed into the best cell on the Google sheets. We should always have as many tags as we now have questions.

We should always end with one thing like what’s pictured beneath.

initial brag document template

As soon as completed, click on Save Deal with and template.

Now that we’ve arrange our mailbox, we have to replace the Reply-To area on our Every day electronic mail zap.

In E mail Parser by Zapier, click on on mailboxes. The mailbox that we created can be listed with an electronic mail tackle. Copy that.

creating a mailbox

We go to our Zaps, discover the Every day E mail Zap, and click on on it to edit it. Within the “Set Up Motion” part, copy the E mail Parser electronic mail tackle into the Reply To area and be sure that our zap is turned on.

brag document outboound email

Head again to the parse information Zap. We’ll have the ability to choose the mailbox we’ve created when establishing our set off. To check our set off, we ship a response to one among our check emails. If we don’t have any, we are able to go into our Every day E mail Zap and ship a check one.

set up a trigger

As soon as we’ve responded, testing the motion ought to give us a response so we are able to proceed.

Subsequent, we have to set the motion of inserting the reply to our questions into the Google sheets.

Seek for Google Sheets and choose the motion occasions to be Create Spreadsheet Row(s).

create spreadsheet rows

Subsequent, we have to check in to our Google account so Zapier has entry to the sheet we made. Observe the directions to take action and click on proceed.

Subsequent, we have to arrange the motion. We have to choose the proper Google Drive, the proper spreadsheet, and which sheet we need to enter the data into.

setting up the action

After that, we have to parse the proper information into the best rows. For date, we are able to choose the date within the drop down. For the questions, we have to choose the best tags that we made earlier within the E mail Parser.

setting up the sheet

As soon as achieved, we are able to check to see if information is being parsed into the proper cells.

Typically the E mail Parser doesn’t work appropriately the primary time and wishes just a little assist ensuring that the corrected information is being parsed.

We should always check it by responding to an electronic mail and seeing what information is being entered.

If we discover that it isn’t correct within the E mail Parser, we have to add additional templates.

Go to E mail Parser and think about emails. Choose an electronic mail the place the information hasn’t been appropriately parsed. Beneath the e-mail, click on on the Edit Additional template.

brag document answers selected

Spotlight the reply and choose the proper tags for them and click on Save Additional Template and check once more. If we discover that it nonetheless isn’t working, attempt including one other additional template.

As soon as all of that’s achieved, watch as we get every day emails despatched to us and see our Google sheets filling up.

Forms of Brag Doc Questions

The world is our oyster with regards to the kind of questions we are able to ask ourself. And we now have no restrict to the quantity we are able to ask. It will be higher to be sure that we don’t ask too many questions or it’ll quickly grow to be a chore to fill out our solutions and we’d keep away from doing it.

Sticking to 4 or 5 is the right quantity to have. These are some examples of some inquiries to ask:

  • What have you ever achieved?
  • What acquired in the best way of reaching your targets?
  • What did you take pleasure in doing?
  • What drained your power?

If we resolve to alter the questions at any time, we’ll have to make the next changes:

  • change the headings within the Google sheets
  • change the outbound electronic mail within the Every day E mail zap
  • change the preliminary template within the E mail Parser
  • add any further tags within the E mail Parser

It’s greater than seemingly that we’ll want so as to add additional templates so the E mail Parser can appropriately map our solutions.


There you’ve gotten it. With just a little assist from Zapier, you may set your self up with every day emails and report the entire solutions to a very powerful inquiries to evaluate your day and report the duties that you simply do, prepared for any future opinions.

To benefit from your solutions, just remember to evaluate them each week, and see in the event you can spot any patterns, both constructive and detrimental, you can take motion on. And don’t overlook to maintain your brag doc useful for when the boss calls you in for a evaluate otherwise you go off to ask for a pay rise!



Please enter your comment!
Please enter your name here

Most Popular

Recent Comments