Setup

Install the AddOn

1. Search for the AddOn on Google Workspace™ Marketplace

2. Install it (I recommend company-wide installation)

First steps:

1. Open a new Spreadsheet, go to Extensions => AutoTeamCal => Setup file

2. Provide permissions to the script

3. Wait for the success message

4. Go to the newly created year-sheet.

5. Right-click on cell A8 (on your email), choose "Smart Chips" and select "Convert to people chip"

6. Go to Extensions => AutoTeamCal => Update Data

7. Tadaaa! You now see all your out-of-office events and working locations copied to the script

The script will update itself automatically every night to show the most recent informations.

Inserting more people

1. Insert a "People Chip" in column (by writing @yourEmail)

2. Copy/Paste the formula in the email column

3. Don't care about styling the new row. Just run "Extensions => AutoTeamCal => Update" and the style will adjust automatically (or simple wait for the next automatic night-run)

Inserting public holidays

1. Give it a name in column A, if you want

2. Put "-" in the email column

3. Mark the cells where holidays are existing (e.g. by a background color)
   Hint: the AddOn will not (yet) fetch public holiday data automatically. You have to prove this yourself or simply delete those rows.

Inserting a "spacer"-row

1. Give it a name in column A, if you want

2. Copy/Paste the formula in the email column (it should show "#REF!")
   Hint: the text in the email column for a sapcer can be anything expect empty, an email or "-".

3. Don't care about styling the new row. Just run "Extensions => AutoTeamCal => Update" and the style will adjust automatically (or simple wait for the next automatic night-run)