Feedback is like a multivitamin—really good for you, but hard to swallow. You may be a little hurt by constructive criticism from a supervisor, so you ignore the actual thing you need to work on. On the other hand, you might forget about that glowing review from a client and fail to bring it up in a job interview or an annual review.
When we don't use feedback to our advantage, we end up hurting ourselves. We forget about our accomplishments, struggle to answer behavioral questions in a job interview, or worse—stunt our professional growth.
Tracking anything manually can be annoying, but Zapier can do the tracking for you. Our automatic workflows, which we call Zaps, send information from one app to another, so you can do things like sending any feedback you get through Slack straight to a feedback spreadsheet.
Meet the brag sheet
We often don't think about our accomplishments until it's time for a performance review or a job interview. A former coworker of mine recognized this and introduced me to the concept of a "brag sheet." A brag sheet is a living document or spreadsheet where you keep track of your work accomplishments. This can be feedback, projects you've worked on, presentations, customer testimonials, work samples, and more. Your occupation will likely influence what you want to track.
Instead of scrambling to find those testimonials and project samples, by maintaining a brag sheet, you'll have your accomplishments and key metrics at the ready for whatever situation you might face.
Your brag sheet is also a place to track feedback—both positive and constructive—and how you've acted on it.
Why should you track feedback? Behavioral questions are common in job interviews, and there are several ways you can approach them. The STAR response method—which stands for Situation, Task, Action, and Result—is one of the most popular techniques for tackling behavioral questions. You describe a specific situation that you faced, the task you needed to do, the action you took to complete the task, and sum up the results.
Inevitably, you'll be asked how you handle feedback. By tracking feedback, taking action, and documenting it, you already have a few STAR answers at the ready for your next interview. Plus, general themes can come up when you receive feedback, and can clue you in to some weaknesses you need to work on—something that comes up a lot in interviews.
Even if you aren't planning on applying for a new job, you should still be tracking feedback, so you'll have a compelling argument for a raise or promotion at your next performance review.
How to set up your brag sheet
Your brag sheet can be a document or spreadsheet. I recommend a spreadsheet because it's easier to organize information—and set up Zaps for it. I use Airtable for my personal brag sheet, but you can use whatever spreadsheet app you like.
I track my published work in my brag sheet. Decide what you'll track, and put each category in a different sheet within your spreadsheet. Specifically, you'll want to make sure feedback is in a sheet separate from anything else you may want to track.
You'll need the ability to categorize your feedback as either positive or constructive. I use the single-select field type in Airtable, but you can also create dropdown options in Google Sheets, Excel, and other spreadsheet apps.
I tend to only remember the constructive criticism instead of the praise. I also find it helpful to include a checkbox to check off whether I've acted on the feedback or not.
Collect your feedback
Now that you have your spreadsheet ready to go, think about whom you receive feedback from. This could be customer testimonials, formal reviews from supervisors or direct reports, or one-offs from your colleagues.
Then, consider all of the channels you receive this feedback from. This might be email, a chat app like Microsoft Teams or Slack, or even an old-fashioned paper review.
We'll use Zaps to populate your brag sheet. To get started with any of the following Zap templates—what we call our pre-made workflows—just click on it, and we'll guide you through customizing it. It only takes a few minutes. You can read more about setting up Zaps here.
Email feedback
Instead of ignoring critical or complimentary emails, set up labels in your inbox for constructive and positive feedback. Then, use a Zap to filter these emails into your brag sheet. Whenever a message has a specific label, the Zap will automatically add it to your spreadsheet.
Add new labeled Gmail emails to rows in Google Sheets
Gmail + Google Sheets
More details
Easily track and manage important email data with this integration by Zapier. Set it up and this Zap will automatically trigger with every new email you label in Gmail, adding its data to a new row on Google Sheets to build a per-label index of your messages.
Add new labeled emails from Gmail to Excel [Business Gmail Accounts Only]
Gmail + Microsoft Excel
More details
There's a better way to store emails than copying each one yourself: Set up this Zap and all your important messages will always end up on your spreadsheet. It will trigger whenever a new labeled email is detected on Gmail, adding its contents to a new row on Excel without taking up any of your precious time.
Add new labeled Gmail messages to Airtable
Gmail + Airtable
More details
Want a quick way to keep track of your most important emails? This Gmail-Airtable integration can help. Set it up, and whenever you label a new email in Gmail, Zapier will automatically copy the email's details and log it to your Airtable database. Set up your Gmail filters to automatically label emails (
You can also use a Zap to automatically add emails matching a search.
Add rows to Google Sheets with new Microsoft Outlook emails
Microsoft Outlook + Google Sheets
More details
Want to spend less of your workday toggling between apps? That's where this integration comes in. Automatically create a new row in a specified Google Sheets spreadsheet whenever a new email is received in your Microsoft Outlook inbox. Keep your Google Sheets spreadsheets organized and up-to-date without ever needing to leave Outlook.
Save new Gmail emails matching certain traits to a Google Spreadsheet
Gmail + Google Sheets
More details
Often it's helpful to store, backup and organize emails matching certain characteristics to a Google Spreadsheet. This Gmail Google Sheets integration makes it a breeze to setup a simple rule (i.e. emails from:
Add new Gmail emails that match searches to Airtable as records
Gmail + Airtable
More details
Automatically track specific emails in a custom database using Gmail, Airtable, and this Zap. This integration will watch your Gmail account for emails that match a search term. When it finds one, it will automatically log the message to an Airtable base as a new record. It's like a tailored view for your most important emails ,with no added clicks or keystrokes.
This workflow serves two purposes. First, it ensures that you save positive feedback. Self-promotion can feel awkward, but less so if it comes from other sources.
Second, the Zap puts constructive criticism into a "time-out." As a writer, I get feedback all the time. I've developed somewhat of tough skin, but even for me, constructive feedback can still sting. Putting some distance for a day or two will allow you to cool down and re-evaluate the critique with a level head.
Slack feedback
As is the nature with work chat apps, it's easy to lose messages. Use a Zap to add saved messages from a chat app like Slack into your brag sheet.
Create rows in Airtable from new saved Slack messages
Slack + Airtable
More details
Sometimes you need to extract good data from your messages by putting it into your database. Let Zapier help make it easier by automating it. This integration creates records in Airtable for new saved messages in Slack. Say goodbye to copy and paste.
Add saved Slack messages to a Microsoft Excel spreadsheet
Slack + Microsoft Excel
More details
Don't lose valuable information sent in a Slack message. Whenever you save a message in Slack, this Zap will add it to a Microsoft Excel spreadsheet. Just choose which spreadsheet and worksheet you'd like your message to go.
Add saved Slack messages to a Google Sheets spreadsheet
Slack + Google Sheets
More details
Keep track of valuable information sent in Slack. When you save a message in Slack, this Zap will add that message to a Google Sheets spreadsheet. Just specify which spreadsheet and worksheet you'd like your Slack messages to go.
You can also add messages into your spreadsheet if you react to a message with a specific emoji.
Create an Airtable record from Slack messages with new reactions
Slack + Airtable
More details
Don't let important messages get lost in your Slack channel. Whenever you add a specific emoji reaction (reacji) to a Slack message, this Zap automatically adds the message to a new record in Airtable. Just pick which emoji you'd like to trigger your Zap.
Create a row in Google Sheets from Slack messages with new reactions
Slack + Google Sheets
More details
Don't let important messages get lost in your Slack channel. Whenever you add a specific emoji reaction (reacji) to a Slack message, this Zap automatically adds the message to a new row in Google Sheets. Just pick which emoji you'd like to trigger your Zap.
Add a new row in Microsoft Excel from Slack messages with new reactions
Slack + Microsoft Excel
More details
Don't let important messages get lost in your Slack channel. Whenever you add a specific emoji reaction (reacji) to a Slack message, this Zap automatically adds the message to a new spreadsheet row in Microsoft Excel. Just pick which emoji you'd like to trigger your Zap.
To ensure you don't forget which emoji to use, you can create your own. I edited my face over a star for my personal emoji I use to save good feedback.
Paper feedback and digital copies
At a previous job, my performance reviews were conducted on paper, so of course, I misplaced them within a week.
If you really are handed a paper performance review—or you receive a handwritten note—you can take a photo of the document on your phone and upload it to Dropbox or another cloud storage app. Then, you can use a workflow to automatically add a file link in your brag sheet. (If you receive a digital copy of your review, such as a PDF file, even better. You save yourself a trip to the recycle bin.)
Add rows to Google Sheets for new Dropbox files
Dropbox + Google Sheets
More details
File directories can become messy and hard to navigate quickly; this Dropbox-Google Sheets integration will help you keep track of all those assets. It will trigger whenever a new file gets uploaded to the Dropbox folder you specify, passing the data over to Google Sheets where a new row can be added automatically to your spreadsheet.
Save links to new Dropbox files in Airtable
Dropbox + Airtable
More details
Ever wish you could organize and share links to your Dropbox files right within Airtable? With this Zapier integration, it's easy. Once you set it up, this Zap automatically copies links to each new Dropbox file right into an Airtable base.
Add new Dropbox files to a Microsoft Excel spreadsheet
Dropbox + Microsoft Excel
More details
File directories can be messy and hard to navigate. Keep track of your files with this integration, which will trigger whenever a new file is in a Dropbox folder. Zapier will automatically add that data to a new row in Microsoft Excel. Just specify which spreadsheet you'd like your information to go.
Add new Google Drive files in a folder as rows in Google Sheets
Google Drive + Google Sheets
More details
Sometimes you want to document or list new files added to a Google Drive folder. Use this Google Drive Google Spreadsheet integration to watch your Google Drive folder and create a Google Sheets spreadsheet row when a new file is added. All new files added after you set up this integration will create a new Google Sheets spreadsheet row so you have an easy table reference of all your files.
Add new rows to an Excel spreadsheet for new files on Google Drive
Google Drive + Microsoft Excel
More details
Losing track of what files you've got on Google Drive, or missing new ones that come in? Zapier can keep a perfect record of everything so you never need to worry about it again. Once active, it will trigger with every new file added to a folder on Google Drive, automatically copying the information over to Excel and adding it as a new row to your spreadsheets.
Log new Google Drive files in Airtable
Google Drive + Airtable
More details
Keep a record of every file that gets added to your most important Google Drive folders with this integration. Set it up, and whenever a file is added to the Google Drive folder you select, Zapier will automatically log that file's details to an Airtable database.
Add new Eventbrite attendees to Mailjet lists
Eventbrite + Mailjet
More details
Rather than messing around with CSV files, use Zapier to automatically add new attendee emails and details to a Mailjet list. Once you set up this Eventbrite-Mailjet integration, new attendees from that point forward are automatically added to your email marketing software.
Save new Box documents to Airtable
Box + Airtable
More details
Now you can organize and share links to your Box documents right within Airtable. This Zapier integration automatically copies links Box documents into an Airtable base.
Add new Box files to a Microsoft Excel spreadsheet
Box + Microsoft Excel
More details
Create an organized file directory with this integration. Whenever you upload a new file to a specific folder in Box, this Zap will automatically add that file's information to a Microsoft Excel spreadsheet. Just specify which spreadsheet you'd like that information to go.
Follow up on feedback
There's no point in collecting this feedback, especially constructive feedback, if you don't act on it. And you're not going to act on it if you don't add it to your to-do list.
Use a Zap to send new brag sheet feedback to your favorite task management app. If you include a due date, remember to give yourself a "cooling-off period" between the time you received that feedback and when you look at it again.
With these workflows, you'll tell the Zap which type of feedback you want to send over—just constructive, for example. Then, whenever a new row is added to your sheet that's marked as constructive, Zapier will automatically send it to your favorite task management app.
Once you've acted on the feedback, you can check it off in your spreadsheet.
Log WordPress posts in a Microsoft Excel spreadsheet
WordPress + Microsoft Excel
More details
Automatically track your WordPress posts with this integration, which will add a new row into a Microsoft Excel spreadsheet every time you publish a new post in WordPress. This integration is an easy way to create an easily-accessible archive of your published posts.
Add new RSS feed items to Airtable as records
RSS by Zapier + Airtable
More details
Import your RSS feed directly into your database when you use this RSS by Zapier to Airtable automation. Once set up, Zapier will watch your RSS feed for new entries. When new entries are posted, Zapier will automatically create a new record in Airtable. You'll have an automatic backup of everything posted to your blog, right in Airtable.
Log RSS feed updates as new rows in Google Sheets
RSS by Zapier + Google Sheets
More details
Keep a log of RSS feed updates in Google Sheets. Zapier can automatically enter RSS feed information into a spreadsheet whenever the RSS feed is updated.
Track your projects or clips
Remember, your brag sheet is also a place to actively track the work you've done—not just stuff other people said you did. Don't forget to capture projects, presentations, published work, or other evidence of your awesomeness.
Whether you're a thought leader, prolific writer, or you just like to dabble with blogging, you don't want to forget about published work. Use a Zap to capture new posts from an RSS feed or a WordPress site in your spreadsheet.
Took the lead on a big project that you're proud of? Gave a stellar presentation? Upload relevant files to your favorite cloud storage app, and use a Zap to add project links to your brag sheet.
Add new Google Drive files in a folder as rows in Google Sheets
Google Drive + Google Sheets
More details
Sometimes you want to document or list new files added to a Google Drive folder. Use this Google Drive Google Spreadsheet integration to watch your Google Drive folder and create a Google Sheets spreadsheet row when a new file is added. All new files added after you set up this integration will create a new Google Sheets spreadsheet row so you have an easy table reference of all your files.
Track new Airtable records in Google Sheets rows
Airtable + Google Sheets
More details
Make sure your spreadsheet data is available anywhere. This Zap lets you send Airtable records to Google Sheets as new rows automatically. Now you have a backup of your most valuable data, and you don't need to lift a finger. Better safe than sorry, right?
And remember, you can always customize these Zaps to work with whatever apps you use.
Now go off and be awesome—but don't forget to track it. You never know when you'll need to provide the receipts.
Hero image by Jon Tyson on Unsplash.