Automate existing Google Sheet™ report on where and what to import data from datasets in Google sheet™, Google Doc™ and web data tables.
Listing updated:27 юни 2025 г.
Works with:
405
Общ преглед
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 for installation and use. Its use of data received from Google APIs will adhere to Google API Services User Data Policy, including the Limited Use requirements.

#SPCsoft #data #import #extract #pull #merge #mark
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.
Additional information
PricingБез парично заплащане
Developer
Нетърговец
Декларация за поверителност
Подаване на сигналFlag as inappropriate
Freedom Data Import will ask for the permissions shown below. Learn more
Freedom Data Import will need access to your Google account
This will allow Freedom Data Import to :
Преглежда всичките ви документи в Google Документи
Преглеждайте и управлявайте електронните таблици, в които е било инсталирано това приложение
Преглежда всичките ви електронни таблици в Google Таблици
Показване на уеб съдържание на трети страни в подканите и страничните ленти в приложенията на Google
Преглежда основния имейл адрес за профила ви в Google
Преглежда личната Ви информация, включително тази, която сте направили обществено достъпна
Отзиви
Language:
Сортиране по:
Google не потвърждава отзивите или оценките. Научете повече за отзивите
No comments
Търсене
Изчистване на търсенето
Затваряне на търсенето
Приложения на Google
Главно меню