> ## Content Index
> Fetch the complete content index at: https://www.jeffsu.org/llms.txt
> Use this file to discover other available public pages before exploring further.

# Google Sheets: Integrate Files and Calendar Events!
- URL: https://www.jeffsu.org/productivity-ping-53/
- Published: 2022-11-11T01:30:02.000Z
- Updated: 2025-09-05T13:12:07.000Z
- Description: #53
- Author: Jeff
- Tags: #newsletter, Google Sheets, Google Calendar, Google Drive

*(you can now* [*filter previous editions*](https://www.jeffsu.org/filter-previous-editions-by-app/) *by application!)*

## 🤔 What is it?

- Previously, if you wanted to link out to another file from Google Sheets, you could only use the hyperlink feature (CMD or CTRL + K)
- There was also no good way to reference calendar events from Sheets directly (for example we wanted to keep track of bi-weekly meetings with our Director)

![](https://storage.ghost.io/c/db/85/db858a9d-1c4f-4993-8042-faa87b9bb3c1/content/images/2022/11/image-21.png)

💡

****Pro tip:** You can [comment directly on this post](https://www.jeffsu.org/productivity-ping-53/#ghost-comments-root) if you have questions or feedback

## 🤷🏻 So what’s new?

You can now use the Smart Chips feature to add files from Google Drive **AND** Calendar events into cells directly!

![](https://storage.ghost.io/c/db/85/db858a9d-1c4f-4993-8042-faa87b9bb3c1/content/images/2022/11/image-22.png)

What’s more, you can hover over the cards for additional context

![](https://storage.ghost.io/c/db/85/db858a9d-1c4f-4993-8042-faa87b9bb3c1/content/images/2022/11/image-23.png)

💡

****Pro tip:** You can also choose to attach the Google Sheet to the Calendar invite!

![](https://storage.ghost.io/c/db/85/db858a9d-1c4f-4993-8042-faa87b9bb3c1/content/images/2022/11/image-24.png)

## ⌨️ Keyboard shortcut

- CMD+OPT+minus with a row or column highlighted to quickly delete that entire row or column (CTRL+SHIFT+minus for Windows)

---

**Follow up questions?** Click “View Online” and you can comment on this post directly! Or give anonymous feedback [here](https://forms.gle/4Dscq21VYF3fjCcn8?ref=jeffsu.org) 📝

**Want someone to be more productive?** Let them subscribe [here](https://www.jeffsu.org/#/portal/signup) 😉

Thanks for being a subscriber, and have a great day!