1. Home
  2. Integrations
  3. Google Sheets
  4. Sync data with a Google Sheets spreadsheet

Sync data with a Google Sheets spreadsheet

This post is also available in: Português

In addition to importing a list of employees from Google Sheets into the department, you can also sync the data.

Here is an example of the Sync data button when you open a department with Google Sheets integration.

Sinc data with the Google Sheets.

The sync function will update all placeholders and employees’ data based on a unique key you define. Good unique key ideas are, for example, name and email.

Connected spreadsheet unique key.

By selecting a unique key, Bybrand will compare it with the existing employee list. And if the data matches, the placeholder data will be updated.

If the field is not found, a new employee is added.

Connected spreadsheet

You can only sync with the connected spreadsheet (The first file you used when creating the department). This connection step can be read at Enable Google Sheets integration.

Connected spreadsheet sync sheet.

If, for some reason, your account doesn’t have a spreadsheet connected, you need to Repopulate the employee list. The action will delete the current employee list and add new ones based on the spreadsheet data.

This can happen if you already have a department created with the integration with Google Sheets.


The repopulate action will rewrite all placeholders from the chosen spreadsheet. Also, it will remove all current employees and create new ones. Therefore, the old share link will no longer work.

So if you shared the signature with the employee previously. You will need to share the new link after doing the action.

Frequent cases

New placeholder in the spreadsheet

If you add a new placeholder in the spreadsheet (a new column), the placeholder is also synchronized with the employee list in the department. But, if you just add the department placeholder (without adding in Google Sheets spreadsheet) when syncing, it will be removed.

Removing employees from the Google Sheets spreadsheet

The sync data feature does not remove the employee from the department if you remove them from the spreadsheet. You need to manually remove it in the department.

Adding employees from the Google Sheets spreadsheet

The script adds new employees if it adds new rows of data in the spreadsheet.

Empty placeholder

If a column is empty, the placeholder is not added. Instead, you need to add the placeholder in the department manually.

Spreadsheet with an empty placeholder


Watch a quick video tutorial with the main steps explained above.

Updated on 11 de August de 2022

Was this article helpful?

Need Support?
Can’t find the answer you’re looking for? Don’t worry we’re here to help!
Contact Support