CODEWITHSUNDEEP
wordpressgoogle-sheetsgoogle-docs
Kinfe
Kinfe

Reputation: 43

Adding data into google sheet by embedding it in my blog

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

Thanks

Upvotes: 1

Views: 47

Answers (1)

Chris Hick
Chris Hick

Reputation: 3094

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

Upvotes: 1

Related Questions