Import CSV Line Items workflow question for Amazon

Conversation Ask Anything
1

I have a question about the Import CSV Line Items workflow from Tiller Community Solutions.

I have used the solution in the past and was able to import the file Order History.csv without any problem.

I tried today after having obtained the info from Amazon. I get an error message when I try to upload the file (see screenshots attached)

Did the mapping change? Is there an easy fix?

Thanks for your help!

Pierre

Screenshot 2026-03-17 at 11.32.59 AM
Screenshot 2026-03-17 at 11.32.59 AM1920Ă—1242 713 KB

Screenshot 2026-03-17 at 11.32.11 AM
Screenshot 2026-03-17 at 11.32.11 AM1920Ă—1242 503 KB

Screenshot 2026-03-17 at 11.21.37 AM
Screenshot 2026-03-17 at 11.21.37 AM1920Ă—1242 376 KB

2

There’s been some other discussion about this recently along with an alternate solution:

1 Like
3

Thank you for the tool. I am 71 years old and somewhat technology challenged! I tried to create the script. I do not understand the meaning of repo (Is this the Library??), so I was not sure what to do when it says “paste the contents of AmazonOrders.js from this repo”, or paste the contents of AmazonOrdersDialog.html from this repo. Below is what I have so far. Can I get help here to understand how to create this script (Import Tool), or should I ask my neighborhood young IT expert, or is there another solution that was discussed in this thread that could be easier for a technology-challenged person. :face_with_raised_eyebrow: Thanks!

Screenshot 2026-03-20 at 11.32.21 AM
Screenshot 2026-03-20 at 11.32.21 AM1920Ă—1242 276 KB

4

@daveahlers Is it possible to adjust the instructions to be beginner friendly?

5

yes, the process is not that simple. I’m sure you’re not alone in this experience.

The challenge is that there are really only three options for running somebody else’s solution within your spreadsheet:

  1. Use the tiller side bar or the community side bar from official Tiller community development people. We all trust these people not to do anything improper with our data or miss anything up. This is easy to install and to use. But I am not a member of that community and not authorized to make contributions to it.
  2. Create my own sidebar and publish it to the Google extensions website. You could then install it very easily and use it. However, my code would have complete access to your Tiller spreadsheet, and there’s no way for you to know with any certainty exactly what it’s doing with your data.
  3. I opted for the third solution: you copy and paste my code into your own project. If you care to look, you can see exactly what the code is doing. But as you can see, it’s a bit challenging.

I will update the instructions to provide more clarity, and I will include some screenshots showing you exactly what it should look like so that you can make yours match. It’s mainly a matter of creating empty files and giving them the right names in the app script folder, and then pasting the contents from my code on GitHub into those files. But give me a few days to update the instructions and it should be more clear.

1 Like
6

Thank you for your kind and prompt answer. Yes, not being computer savy, it is very challenging for me to understand what you mean. I could pay an IT college student to help me install your solution but not the most convenient solution!

Yes is unfortunate that the Tiller sidebar is no longer working. I get the error message (see screenshot in my original question). “The Importer does not recognize the uploaded file”. Would a simple tweak each time I run the solution work? Could it be as simple as mapping change, which, if I understand correctly, would be to change the column name in the Order History.csv file I got from Amazon. Your comments are very much appreciated. Thanks again. Pierre

7

I tried changing the column names back to their originals, but still could not import. there were other changes as well, which is why I wrote my own. And I imagine it will break again. You can see a longer discussion here: Amazon orders CSV format has changed as of 2.19.26 - #30 by daveahlers

8

Ok, instructions updated, let me know if that helps.

9

Thank you for taking the time to redo the instructions for me.

However, I am not an IT specialist, and at first glance, the instructions sound Greek to me.
For example:

+ → Script → name it AmazonOrders → paste the contents of AmazonOrders.js from this repo. It appears as AmazonOrders.gs.

I have no idea what a repo is. Where is the content of AmazonOrders.js?

I might end up entering all the Amazon info manually.

Unless there is an easier way? Let me know.

Thanks for trying to help.

Pierre

10

Hi Pierre - those are the old instructions. Did you try refreshing the page containing the instructions? They should look like this:

How to get the code out of this page and into Apps Script

  1. Open your Tiller Google sheet.

  2. Click Extensions, then App Script

  3. A new window will appear with a list of files on the left. Chances are you’ll only have one file named “Code.gs”

  4. Switch back to this page

  5. Click on AmazonOrders.gs in the file list above.

  6. Just to the right of the Raw button is a copy button (two little squares). Click that to copy the code to your clipboard.

  7. Switch back to the AppScript window.

  8. Click the + sign.

  9. Select Script as the file type from the dropdown

  10. Name the file exactly AmazonOrders. The .gs part will be added automatically when you save it.

  11. Once the file is created, you will see a new area to the right of the file name with a few lines of text like “function myFunction”. Delete all that text.

  12. Paste in the code you copied from this page.