Mark on your existing user report sheet on where to import data/summary from current/another Google sheet, Google doc and web data tables. It enable you to define and format your report sheet freely.
应用详情更新日期:2024年5月3日
适用于:
333
概览
This add-on automates your existing Google Sheet ™ report to import data from another Google sheet, Google doc or web data tables which have data name on first row. You simply mark once on your report sheet where to get, filter, list, count, sum or import the data. Report runner will import and highlight the updates. You can verify and export the report without the markers.

How to install?

Go to Google Marketplace to install. After Installation, your sheet menu Extensions will have this add-on . If not, please re-open your sheet.

How to use?

1. Open your data sheet. From this add-on menu, select Show spreadsheet ID and copy the ID to clipboard. For Google doc, copy the ID from URL. For web, copy the URL.
2. Open your report sheet. For report table, highlight the columns that you want this add-on to pull in data from your data sheet. For data cell, highlight the cell.
3. Open this add-on menu, select Open marker sidebar and pick the marker for list, label, count, sum, copy, or tag.
4. Enter the marker details.
5. To run your report, open this add-on menu and select Run report . A log sheet MRR Log will display the running status.
6. To export your report, open this add-on menu and select Export report. A copy without markers will be copied to your Google drive root directory (defaulted by Google).
7. To test a new marker, open this add-on menu and select Select markers for test run. On the displayed sheet MRR Log, tick the markers. Open this add-on menu and select Run report to test run.
8. To reset the data update tracking, open this add-on menu and select Reset data update tracking. The tracking notes will be reset to blank.

This add-on is free. Its use of data received from Google APIs will adhere to Google API Services User Data Policy, including the Limited Use requirements.

Your donation is appreciated to sustain and enhance it in Google Marketplace for your usage.

Enhancements:
2023-06-01 support pulling date from web table.
2023-02-06 support pulling data from the nth table in Google Doc. 
2023-01-16 support pulling data from Google Doc.
其他信息
定价免费
开发者
Freedom Data Import”将请求获得以下权限。了解详情
Freedom Data Import”将需要访问您的 Google 账号
这样可让Freedom Data Import
查看您在 Google 文档中的所有文档
查看和管理其中已安装此应用的电子表格
查看您在 Google 表格中的所有电子表格
在 Google 应用的提示和边栏中显示和运行第三方网页内容
查看您的 Google 账号的主电子邮件地址
查看您的个人信息,包括您已公开的任何个人信息
评价
语言:
排序依据:
Google 不会核实评价或评分。 详细了解评价
没有评论
搜索
清除搜索内容
关闭搜索框
Google 应用
主菜单