> ## 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 Docs: Automatically link to Sheets
- URL: https://www.jeffsu.org/productivity-ping-58/
- Published: 2022-12-09T01:00:13.000Z
- Updated: 2025-09-05T13:11:46.000Z
- Description: #58
- Author: Jeff
- Tags: #newsletter, Google Docs, Google Sheets

Before diving into the tips today, I just wanted to thank each and every one of you for being a subscriber. I started Productivity Ping a little more than a year ago and can’t believe we now have over 7,000 readers (with an average 51% open rate)!

As we head into 2023, I’d love to [hear your honest feedback](https://forms.gle/m5F8PLZhqDBB9EPG6?ref=jeffsu.org) so I continue improving on this newsletter and providing as much value as possible to you 😁

Onto this week’s tips:

## Google Docs <> Sheets Hack

If you’ve watched my [note-taking video](https://youtu.be/T0qhJdHLJTc?ref=jeffsu.org), you know that I like to hyperlink to working spreadsheets at the top of the Google Doc, like so:

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

### Smart Chips integration

First up, you can now use Smart Chips to link directly to Google Sheet files. Instead of having to copy and paste the URL as a hyperlink, you can simply type “@” to link to the file directly

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

### Paste table directly in Google Docs

Taking this 1 step further, you can now paste a table directly from Google Sheets into Google Docs

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

💡

****Pro tip:** Use “Paste Linked” so that if the original cells gets updated, the table in Google Docs is automatically updated as well

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

This is super useful in situations where it makes sense to track progress in a spreadsheet but you review and present status updates in Google Docs (e.g. during team meetings or 1:1’s with your manager)

[Take me to the comments!](https://www.jeffsu.org/productivity-ping-58/#ghost-comments-root)

## ⌨️ Keyboard Shortcut

- CMD + Option + M to add comment in Google Docs (CTRL + Alt + M for Windows)

---

**I’m always looking for ways to improve** so give me 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!