Google Sheet / Embed / Make Copy

• 

  strategyfpl · Member · Jul 13, 2018 at 5:21 pm

  • Copy link
  • Add topic to favorites

  Hi,

  I’m looking to do the following:

  – 1) embed a Google Sheet
  – 2) allow users to edit this embedded Google Sheet
  – 3) ensure that the original data is not changed or deleted. This can be done in a traditional Google Sheet by replacing ‘edit’ with ‘copy’ in the URL. This then forced the user to ‘make copy’.

  Does anyone know if this is possible to achieve all three with word press?

  Thanks in advance
  Ryan

• 

  timethief · Member · Jul 13, 2018 at 5:24 pm

  • Copy link

  You failed to post the URL starting with https:// of the site but unless it’s a site hosted by WordPress.COM you are posting to the wrong support forum.

  To save time you can type the actual URL of the site you are referring to into http://whoishostingthis.com to determine who hosts the site so you know where to post for support.

  WordPress.COM hosted sites and WordPress.ORG software installs on paid hosting and local installs have different logins and different support documentation.

  We provide support only for WordPress.COM hosted sites on our servers and your site may not be among them. WordPress.COM and WordPress.ORG are completely separate and you can read the differences here http://en.support.wordpress.com/com-vs-org/

  For hosting issues contact your web host. For software issues post to the WordPress.ORG support forums.

  The wordpress.ORG support forum is at http://wordpress.org/support.
  The wordpress.ORG login link is here https://login.wordpress.org/
  If you do not have an account yet then click Create an account https://login.wordpress.org/register/ and if you have lost an account password click Lost password? https://login.wordpress.org/lostpassword/
  WordPress.org support docs are at https://codex.wordpress.org/Main_Page
  See also https://apps.wordpress.org/support/ for app support.

• 

  strategyfpl · Member · Jul 13, 2018 at 5:27 pm

  • Copy link

  I’ve not created the website yet.
  Before I do, I wanted to know if this functionality is possible?
  Thanks
  Ryan

• 

  timethief · Member · Jul 13, 2018 at 5:32 pm

  • Copy link

  I do not use Google docs but we do have a support doc at https://en.support.wordpress.com/google-docs/ that may answer your questions.

  If not, type modlook into the sidebar tags on this thread for a Staff follow-up. How do I get a Moderator/Staff reply for my question? https://en.support.wordpress.com/getting-help-in-the-forums/#how-do-i-get-a-moderatorstaff-reply-for-my-question. Also subscribe to this thread so you are notified when they respond and be patient while waiting. To subscribe look in the sidebar of this thread, find the subscribe to topics link and click it.

• 

  timethief · Member · Jul 13, 2018 at 5:33 pm

  • Copy link

  re: 2 and 3

  If you wish to issue invitations to add official users to your site see these support docs for details:
  https://en.support.wordpress.com/user-roles/
  https://en.support.wordpress.com/user-roles/#adding-users-to-your-site

• 

  kokkieh · Staff · Jul 18, 2018 at 5:21 am

  • Copy link

  Hi there,

  All we offer is the ability to embed the sheet on your site, and the embedded version of the sheet on your site cannot be edited at all but is read-only. This is not a limitation on our end, but is part of how publishing a Google Sheet to any website works.

  The actual sheet will still be hosted on Google’s systems, and someone will have to access it there via the shared document link in order to edit it. So what changes can be made and by whom entirely depends on the permissions you set in Google Sheets itself.

  When you publish the sheet you’ll be able to select a setting that any changes to the sheet itself should automatically cause the embedded version to update.