Setup your data sheets
To get started, create a sheet named ‘mapping’ with the following columns: feedback receiver email and feedback giver email. If there are multiple feedback givers, list them in separate rows, keeping the feedback receiver unchanged. Optionally, include a ‘form’ column if you are mapping multiple forms.
To enhance functionality, add a sheet named ‘master’ to store extra master data for feedback receivers and givers. The only mandatory column is ‘email’, but you can include additional columns like title, department, etc., to personalize notifications and reports.
Add and Manage Forms
Forms screen lets you set up Google Forms to collect 360-degree feedback seamlessly. Here you can add Google Forms for each feedback type (e.g., peers, managers, subordinates).
You can design the Google Forms for collecting feedback as you need and add any types of questions as per your requirement without any constraints. When sending the Forms, Feedback 360 does not make any changes to the design or questions. It only adds ‘Feedback receiver email’ as the first question which is pre-populated in the notification messages that are sent.
Specific Google Form question types such as ‘Scale‘ are reported in an aggregated way and hence can be used to aggregate and report feedback ratings if needed. For example, if there is a question of type Scale in your Google Form with low 1 and high being 5 and if 6 people have completed feedback, then the responses of this scale question are also reported in form of an aggregated average feedback rating.
You can add a Google Form using the Form ID or the Google Form’s Edit URL. Please copy the URL from the edit page of the Google Form for this. Note that you need to be the owner or need to have editor access to the Google Forms that you are adding.
You can then use the Form labels in the mapping sheet’s ‘form‘ column to specific feedback givers for better organizing the feedback report.
In case of single Google Form feedback project, it is okay to not have the form column in the mapping sheet. If you only have a single Google Form attached in the Forms screen, it is used as the default form.
You can also use Form Settings to control the user experience of feedback givers with the chosen Google Forms. This gives you control to restrict feedback receiver emails to a specific domain pattern (in case you want to limit feedback receivers only within your company or specific domain patterns)
For all the forms that you add, Feedback 360 appends a special field ‘Feedback receiver email’ as the first question. This field should not be deleted for the add-on to function as expected.
Send Notifications
Notifications screen lets you create personalized Email and Slack notification reminders to be sent to feedback givers.
Here are details of various fields in this screen:
- Sender Name: This can be used to customize the name field in the notification emails or the display username of the Slack bot
- Subject: This would be used as the subject line of the notification email
- Notification message body can be customized using basic visual formatting such as Bold, Italic, Links etc. You are also required to add the
{{feedback_receiver_list}}placeholder here, which will be replaced by the feedback receiver list with links to Google Form to provide feedback. - Feedback Receiver List Item Template: This can be used customize each item in the feedback receiver list. You can use the available placeholders to customize this. Placeholders other than
{{Email}}will only be available if you have data populated in your master sheet.
Notifications can be sent as Emails and via a Slack Bot. Email notifications will be sent via the Email address that is using the Feedback 360 add-on. Sending Slack Bot notifications needs a valid Slack Bot API key.
You can also schedule notifications as daily reminders to be sent at a specific time of the day of your choice. This feature can be accessed via the ‘Schedule’ button.
Notifications are always only sent to those feedback givers who have not completed their feedback tasks.
Generate Feedback Reports
Reports screen lets you generate and email feedback reports to designated people. This screen also lets you configure how the feedback is consolidated and displayed in the feedback report.
Feedback Giver & Receiver templates are a way to customize how Feedback Giver and Receiver names show in the reports using placeholders. You can use the available placeholders to customize this. Placeholders other than {{Email}} will only be available if you have data populated in your master sheet.
You can bulk send feedback reports of multiple feedback receivers to designated people of your choice via email. Multiple feedback receiver emails can be added (one email address per line) for such bulk sending. Reports can be emailed to designated people of your choice via email. You can also provide a list of multiple comma separated email addresses in this field.
Note that specific Google Form question types such as ‘Scale’ are reported in an aggregated way and hence can be used to aggregate and report feedback ratings if needed [more details…]
You may also choose to send the feedback report as Anonymous. In case of Anonymous reports, no details of feedback providers are reported.