Sample Embedded Google Sheet

To link a Google Sheet, follow these steps:

  1. Create the Google sheet and click "Share"
  2. Click "Advanced"
  3. Select "Change..." under "WHO HAS ACCESS"
  4. Choose "Anyone with the link" (that means anyone who accesses your web page can view the sheet!)
  5. Copy the link under "Link to share", then hit "Done" (the link will look something like this: https://docs.google.com/spreadsheets/d/1b7GlmHL_Wvtajurg7TC4_rUuQg5Osv-GrfTf0gkPwMo/edit?usp=sharing)
  6. Put that link on your webpage:
    1. Log in to Drupal, find your page and click "Edit Draft" or "New Draft" (whichever one appears)
    2. Type the text for the link, like this: Contractor Spreadsheet
    3. Highlight that text, then click the hyperlink icon
    4. Enter the link in the URL field (the same one from Step 5)
    5. Click "OK", and your link will show up like this: Contractor Spreadsheet
    6. Save and publish your page to make your changes public!

To embed a Google Sheet, follow these steps: 

  1. Create a Google sheet and click "File", then "Publish to the web..."
  2. Select "Embed", then click "Publish"
  3. Copy the "iframe" embed code (the code will look something like this: <iframe src="https://docs.google.com/spreadsheets/d/e/2PACX-1vQbIjVkoClags0I3UMidnz4lnM84y82EFYqFnlq0f5GbOamDUBg2OP__d1BJw0tuKk7wRwN3UV0O0-t/pubhtml?widget=true&amp;headers=false"></iframe>)
  4. Post that code on your webpage:
    1. Log in to Drupal, find your page and click "Edit Draft" or "New Draft" (whichever one appears)
    2. Down below your text editor, you'll see a dropdown called "Text format": select "Full HTML"
    3. Click the "Source" icon
    4. Paste your iframe code (from step 3 above)
    5. Double click the "IFRAME" object that shows up
    6. Set the width and height to 1000 (at least), then checkmark "Enable Scrollbars"
    7. Save and publish your page to make your changes public! Every time you update your Google sheet, your changes should be automatically pushed out to your webpage as well.

See sample embedded page below: