1

Is it possible to add data into google sheet from my wordpress page by embedding the google sheet.

Thanks

m4n0
  • 29,823
  • 27
  • 76
  • 89
Kinfe
  • 43
  • 6

1 Answers1

1

You can click File > Publish to the web > Embed, and then paste the iframe html into your wordpress post

Then back in the sheet file, click File > Share and change the permission to 'Can edit' and copy the sharing link

Then paste this sharing link over the default 'pubhtml' you previously added to you wordpress post, so that it looks something like:

isrc="https://docs.google.com/spreadsheets/d/1dNcQaUCaHXGt26sKwteSghwUCZPM4rTcH0oFoM/edit?usp=sharing?widget=true&headers=false">

An editable version of your sheet file should now appear on your wordpress post

Chris Hick
  • 3,004
  • 1
  • 13
  • 15
  • and I have to login to gmail to see the content? – Kinfe Aug 24 '15 at 18:27
  • the html you generate in the first step (after clicking 'Embed') will just create a read-only copy of the file in your Wordpress post. To make it editable, you need to replace the section between "https" and "pubhtml" with the code you get from the second step (after clicking Share). Also, as long as you have set the permissions to 'anyone can edit' then you shouldn't need to log in to see the content – Chris Hick Aug 24 '15 at 20:15