How to create JSON feed from Google Sheets Data

How to create JSON feed from Google Sheets Data

Laurence Svekis ? Laurence Svekis ?

Laurence Svekis ?

发布日期: 2021年1月7日
+ 关注
  1. Create a Google Sheet
  2. Under File Menu Select ‘Publish to the web”
No alt text provided for this image


  1. Select under Link Sheet and as Web Page – Click Publish
No alt text provided for this image


  1. Check the URL provided to ensure page is visible on the web
  2. Copy Sheet ID
No alt text provided for this image


  1. Place the id in the JSON URL ‘https://spreadsheets.google.com/feeds/list/’+id+’/1/public/values?alt=json’;
  2. const id = ‘1H2xq8J5uZKDABgu1JlvV-nVWKqZoV8_UpB_D_snOrLo’;
  3. const url = ‘https://spreadsheets.google.com/feeds/list/’+id+’/1/public/values?alt=json’;

7. Open URL into a browser to ensure you can see data as JSON

8. Using fetch connect to the web URL with Sheet data.


Vrushali Hiwarkar

Technical Lead ? IT at Old Mutual Insure

2 年

const url = ‘https://spreadsheets.google.com/feeds/list/’+id+’/1/public/values?alt=json’; this is not working

赞
回复
md.zaheed ehsan

Tax Lawyer

4 年

Thank you for

赞
回复
Arockia Liborious

Linkedin Top Voice | Author | Artificial Intelligence and Machine Learning

4 年

Good one. I was not aware of this

赞
回复
1 次回应
Steve Sullivan

I like helping people where I can. I am considered a good listener, an idea man, and an excellent advisor. I am a survivor of AML, and always willing to listen, encourage, and offer help to those battling cancer.

4 年

Thanks for the easy documentation. As an old tech writer, you did a good job.

赞
回复
1 次回应
MamaLiz ???Liz Franklin

TIME 2B GREAT 4 Kids-Teens-College| International Author-Keynote Speaker-Workshops-Youth Ministry-Initiatives| WHO'S WHO in USA| TOP 50 MOST IMPACTFUL| 250 RISING STAR INFLUENCERS| TOP 100 THOUGHT LEADERS|??Mama Liz???

4 年

Thank you for sharing, Laurence Svekis

赞
回复
1 次回应
查看更多评论

要查看或添加评论，请登录

Laurence Svekis ?的更多文章

社区洞察

其他会员也浏览了