Hi, thanks for the Sunday assist!
Someone replied to your post.
| daveahlers
April 12 |
Hi Malcom - great that you’re trying it out. So far I think I’m the only one to test it - so there are likely to be some bugs based on different tiller and amazon files.
Gotcha - glad to be early tester.
I’m still waiting for Google to approve it’s listing in Amazon store which will eliminate the install pain - but the code you are using should run just fine. Some answers:
- Timezone: Based on your comment about execution error, looks like there’s a syntax error in that line. If you simply copy/pasted my appscript.json, it should run fine. Did you edit it by any chance? You can delete this line and it will default to your google sheet settings.
Yes, I had in fact edited the json to replace the timezone line with my timezone. I took your advice and removed the timezone line and reloaded the file but I still get the error. I copy/pasted your json and saved and reloaded the file and still get the same error.
Apr 12, 2026, 6:01:42 PM
Error
Exception: Invalid argument: timeZone. Should be of type: String
at amzFormatImportTimestampStr_(amazonorders:1263:20)
at importAmazonBundleChunk(amazonorders:3669:10)
- Step 2/3: you can ignore this step if you’re not prompted
- Step 3: Google calls it authorization, but the screen calls it granting permissions. If the code partially ran, even with a syntax error, you should have already authorized the code to run
- This is related to permissions issue. The On_open function should prompt you for permissions, you approve, then the menu appears. If you were able to run it from appscript, and force permissions request that way, the top menu will now automatically appear each time you refresh the sheet.
FWIW I only get the Tiller Tools menu as sub-menu of Extension. But The Amazon Import item is there and runs when chosen.
- Deploy is not needed unless you want to create your own Marketplace Addon. I don’t recommend this level of masochism.
Your other comments:
- Sounds like the code for reading categories is not finding your categories sheet. Can you confirm a
Categories sheet exists, row 1 is the header, and category names start in A2 (or lower) in column A?
Yes, I am using the default Tiller supplied worksheet, and the first few rows of the Categories sheet look like this:
Category | Group | Type | Hide From Reports | Jan 2026 | Feb 2026 | Mar 2026 | Apr 2026 | May 2026 | Jun 2026 | Jul 2026 | Aug 2026 | Sep 2026 | Oct 2026 | Nov 2026 | Dec 2026 |
- | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
Charity | Discretionary | Expense |
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
Restaurants | Discretionary | Expense |
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
- Readme.md has a bit more info on this, but I can see it could be clearer. Basically, we have to know which credit card was used for each transaction. You do that by editing the Credit Card table on the AMZ Import tab. Add your 2 new accounts there using mine as an example, and delete my sample accounts.
- That syntax error sounds related to appscript.json having an invalid timezone entry. I pushed a fix to github to ignore invalid timezones. Copy down amazonorders.gs again.
That seemed to fix it.
If you run into more issues,
Great, I have another issue… here is what appears on bottom of the Import dialog after clicking Import:
This process may take up to 2 minutes for large Tiller and Amazon files.
Importing orders
- Error: Transactions sheet headers or AMZ Import Tiller labels: no column header matching “Metadata” (METADATA).
Importing digital orders
- Error: Transactions sheet headers or AMZ Import Tiller labels: no column header matching “Metadata” (METADATA).
Importing digital returns
- Error: Transactions sheet headers or AMZ Import Tiller labels: no column header matching “Metadata” (METADATA).
Importing order returns
- Error: Transactions sheet headers or AMZ Import Tiller labels: no column header matching “Metadata” (METADATA).
Finishing
0 new transactions, 28.7s.
Import finished
No new rows were added to Transactions this run. Check the status above for duplicates, cutoff date, or skipped files. The sheet was still sorted and the import view filter may have been refreshed.
Here is a screenshot showing the content of the new AMZ Import worksheet:
happy to jump on a chat to avoid tedious back and forth.
Cool! I’m sitting in a google meet right now if you are able to chat… https://meet.google.com/qqf-ofgj-vzx
Otherwise, perhaps suggest a date/time for chatting?
I’d like to have this tool be useful to more than just me.
Fantastic! Thanks for all this.
~ Malcolm Cook
