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.