Google Apps 脚本将 gmail 中的 xlsx 超链接添加到电子表格中
我有一个非常具体的任务，我发现了很多类似的问题，但它们都略有不同。
该脚本每天上午 10 点根据这篇文章的最佳答案触发：是否可以自动化 Google 电子表格脚本（例如，无需事件来触发它们）？
我每天都会收到一份报告，其中包含我想要添加到现有脚本中的行电子表格，所以我在上午 8 点左右收到报告，然后通过脚本将附加数据添加到电子表格中。
情况是，该电子邮件是来自 Amazon Display Advertising Analytics (Amazon DSP) 的自动报告，并且 xlsx 文件带有超标线，而不是附件。
因此，理想情况下，该脚本从我的 Gmail 帐户获取电子邮件列表，搜索特定电子邮件并检索结果。获取超链接的 Excel 文件并复制内容，但第 1 行（即标题）除外。将内容添加到现有电子表格中。
最后我得到了一位Fiverr专业人士的帮助，他编写了代码，所以出于对他的尊重我不会发布他的作品，所以如果你对它感兴趣或者需要它，请给我写私信！
I have a very specific task and I found many similar questions but they are all slightly different.
The script is triggered every day at 10am based of the top answer of this post: Is it possible to automate Google Spreadsheets Scripts (e.g. without an event to trigger them)?
I receive a report every day with lines that I want to add into the existing spreadsheet, so I get the report around 8am and then the attached data is added to the spreadsheet through the script.
The situation is that the email is an automated report from Amazon Display Advertising Analytics (Amazon DSP) and the xlsx file is hyperlined, not attached.
So the script, ideally gets the email list from my gmail account, searches for a specific email and retrieves a result. Gets the hyperlinked excel file and copies the content, except for row 1 which are the headers. Adds the content to an already existing spreadsheet.
In the end, I had the help of a Fiverr professional who scripted the code, so out of respect for him I won't publish his work, so if you are interested in it or if you need it, write me a private message!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
最后我得到了一位Fiverr专业人士的帮助，他编写了代码，所以出于对他的尊重我不会发布他的作品，所以如果你对它感兴趣或者需要它，请给我写私信！
In the end, I had the help of a Fiverr professional who scripted the code, so out of respect for him I won't publish his work, so if you are interested in it or if you need it, write me a private message!