Tools
One problem, one tool
Each tool finishes one job. Use them separately or together. You can read the code of every one before you use it.
How it works
Set up once,
Set up once,
use every closing cycle
Report_Shopee E-comGoogle Sheets
Tab M_ShopeeHeader in row 1
Folder for Shopee fee PDFsDrop files here
Code.gsApps Script
// Edit only these two lines
var folderId = 'YOUR_FOLDER_ID';
var sheetId = 'YOUR_SHEET_ID';Add a serviceAdded
ServiceDrive API
Versionv2
IdentifierDrive
Your script wants access toRead files in Google Drive and edit this sheet
CancelAllow
M_ShopeeCheck against PDF
| Document no. | Total (THB) | Result |
|---|---|---|
| TIV-2569-1021 | 1,284.00 | Match |
| TIV-2569-1022 | 642.00 | Match |
| TIV-2569-1023 | — | Recheck |