This is a job that posts new items from an Amazon wishlist to a spreadsheet on Google Drive.
- Google Service Account
- A Google Drive spreadsheet you want to write to. You must share it and give edit access to the client email assigned to your app by Google.
- An Amazon wishlist you want to read from. Must be marked as public.
- Amazon S3 Bucket
- A server running Amazon Wishlister
That last one provides an endpoint to scrape a wishlist page from Amazon. At the time of this writing, scraping is currently necessary as Amazon doesn't provide access to a wishlist through their API. I recommend using a free Heroku PHP instance
Next clone this project and run:
npm install
Now create a file titled .env with the following contents, and fill in your environment keys.
GOOGLE_SPREADSHEET_KEY=''
GOOGLE_CLIENT_EMAIL=''
GOOGLE_PRIVATE_KEY=''
AMAZON_WISHLIST_ID=''
AWS_ACCESS_KEY=''
AWS_SECRET_KEY=''
AWS_REGION=''
S3_BUCKET=''
For deploying, you can host this anywhere. If you're using Heroku, you can run the following to load your environment variables into your instance.
./bin/heroku-config