{"id":2766,"date":"2021-07-13T16:10:41","date_gmt":"2021-07-13T19:10:41","guid":{"rendered":"https:\/\/www.bybrand.io\/docs\/?post_type=ht_kb&p=2766"},"modified":"2025-05-27T13:24:24","modified_gmt":"2025-05-27T16:24:24","slug":"googlesheets-sync","status":"publish","type":"ht_kb","link":"https:\/\/www.bybrand.io\/docs\/article\/googlesheets-sync\/","title":{"rendered":"Sync data with a Google Sheets spreadsheet"},"content":{"rendered":"\n

In addition to importing a list of employees from Google Sheets<\/a> into the automation, you can also sync the data.<\/p>\n\n\n\n

Here is an example of the Sync data<\/strong> button when you open an automation with Google Sheets integration.<\/p>\n\n\n\n

\"Example<\/figure>\n\n\n\n

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.<\/p>\n\n\n\n

\"Connected<\/figure>\n\n\n\n

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.<\/p>\n\n\n\n

If the field is not found, a new employee is added.<\/p>\n\n\n\n

Connected spreadsheet<\/h2>\n\n\n\n

You can only sync with the connected spreadsheet (The first file you used when creating the automation). This connection step can be read at: Enable Google Sheets integration<\/a>.<\/p>\n\n\n\n

\"Connected<\/figure>\n\n\n\n

If, for some reason, the automation does not have a spreadsheet, an alert message will be displayed. With an option to reconnect a spreadsheet.<\/p>\n\n\n\n

\"Google<\/figure>\n\n\n\n

Click the Select<\/strong> link to set a default spreadsheet again.<\/p>\n\n\n\n

Repopulate<\/h2>\n\n\n\n

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.<\/p>\n\n\n\n

So, if you shared the signature with the employee previously. You will need to share the new link after doing the action.<\/p>\n\n\n\n

\n\n\n\n

Frequent cases<\/h2>\n\n\n\n

New placeholder in the spreadsheet<\/h3>\n\n\n\n

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

Removing employees from the Google Sheets spreadsheet<\/h3>\n\n\n\n

The sync data feature does not remove the employee from the automation if you remove them from the spreadsheet. You need to manually remove it.<\/p>\n\n\n\n

Adding employees from the Google Sheets spreadsheet<\/h3>\n\n\n\n

The script adds new employees if it adds new rows of data in the spreadsheet.<\/p>\n\n\n\n

Empty placeholder<\/h3>\n\n\n\n

If a column is empty, the placeholder is not added. Instead, you need to add the placeholder in the automation manually.<\/p>\n\n\n\n

\"Spreadsheet<\/figure>\n\n\n\n
\n\n\n\n

Video tutorial<\/h2>\n\n\n\n

Watch a quick video tutorial with the main steps explained above.<\/p>\n\n\n\n

\n