Amazon Seller Central

How To
1

I want to be able to take a report from Amazon Seller Central, Take each of the link items one by one. In each line item, there is a link to personalization data for each order. I need to get that personalization data into a spreadsheet on Google.

Amazon requires that we be logged in to see the personalization data. It’s presented in a web page, which I think an http get would be used.

Has anyone done this with Make?
When I pull the report data from Amazon, that link isn’t included, so I can’t pull up the page and parse the data.

When I download the order report, the link is in a .txt file that is provided. Is there a way I can add a link to that TXT report file to a Google sheet and each time that sheet is updated, have Make download the TXT file and pull that link from the txt file (which is essentially a csv file of the data)?

Thanks for any direction. I’m pulling my hair out and I’m also new to Make… but learning.

Thanks in advance.

2

Don’t do that – read my Make for Make Newbies Video Series I: All About that Data instead.

You are going to probably need to use a web page parser. There are MANY ways to do this. Search the community for a few examples.

3

Thank you so much! I’ll read what you suggested.

1 Like