How can I link a Google sheet to my document?

With just a few clicks, you can link your Google Sheets data as tables within your document. Just drag and drop Google Sheets blocks into your document and link your existing sheets to them. Once the Google Sheets data has been added to your document, you can keep them linked (in which case whatever changes you make in the source Google Sheets will be updated in the document upon refresh), or you can unlink them (in which case the data will not change in your document even if changes are made in Google Sheets).

To link existing Google Sheets within your document:

1. Drag-and drop Link to Google Sheet block on to your document.
   
   

2. Click Connect to Google Sheet.
   

3. Select the sheet you want to link.
4. Select the Use the first row as header option if you want to use the first row in the Google Sheet as the header of the table in the document.
5. Click Sync selected sheet to synchronize the Google Sheet in your document. Now the files are linked, and any changes made in Google Sheets will be reflected in your document when you refresh it.
6. Click Show in the document.
   
   The selected sheet data is added to the document as a table.
7. To see the latest changes you’ve made in the source Google Sheet appear in the document table, click Refresh and resync.