google docs中的importxml并返回google搜索结果 [英] importxml in google docs and returning a google search result

问题描述

我正在尝试使用importxml将google搜索的结果上传到我的google文档中，而过去可以正常工作的代码不再可用.我有 = IMPORTXML(" https://www.google.com/search?q=site :[query]& num = 100& start = 1，"//引用)

I am trying to upload a result of a google search into my google docs using importxml and the code that used to work doesn't anymore. I have =IMPORTXML("https://www.google.com/search?q=site: [query]&num=100&start=1","//cite")

我的错误信息是 无法获取网址: https://www .google.com/search?q = site:[query]& num = 100& start = 1

My error message is Could not fetch url: https://www.google.com/search?q=site:[query]&num=100&start=1

有人可以告诉我为什么这不再起作用了吗?

Can someone tell me why this doesn't work anymore?

推荐答案

尽管请求是从其自己的IP之一发出的，但Google最近一直在阻止从Apps脚本和Google表格发出的搜索请求.他们可能这样做是为了防止刮擦.

Google has lately been blocking search requests made from both Apps Scripts and Google Sheets though the requests are made from one of their own IPs. They probably do this to prevent scraping.

这篇关于google docs中的importxml并返回google搜索结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！