How can I link a Google sheet to my document?
  • 11 Dec 2020
  • 1 Minute to read
  • Dark
    Light
  • PDF

How can I link a Google sheet to my document?

  • Dark
    Light
  • PDF

Article summary

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).

Revv Link Google Sheets

To link existing Google Sheets within your document:

  1. Drag-and drop Link to Google Sheet block on to your document.
    Revv Link GoogleSheet
  2. Click Connect to Google Sheet.
    Revv Connect 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.
    Revv Google Sheet Linking
    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.



Was this article helpful?

ESC

Eddy AI, facilitating knowledge discovery through conversational intelligence