Amazon API Redirect URI Setup
Budget: $12 – $30 SGD
Hello,
I'm looking for a freelancer experienced with Amazon SP-API integration using Google Apps Script.
Project Goal:
I need to set up a custom solution to automatically pull my Amazon Seller Central sales order data via the Selling Partner API (SP-API) and sync it into a Google Sheet.
What I've already done/My current setup:
Google Apps Script: I have a Google Apps Script already written and deployed as a web app. It's designed to fetch Amazon orders and populate them into a Google Sheet.
I have my Google Apps Script Web App URL (this acts as my REDIRECT_URI).
My Google Sheet ID is set, and the destination tab name is 'Sales Order'.
Amazon SP-API App: I have registered a private SP-API application in my Amazon Seller Central Developer Central account.
I have my App Name, App ID, LWA Client ID, and LWA Client Secret.
AWS IAM User: I have created an AWS IAM user with programmatic access and assigned the necessary policies to generate Access Key and Secret Key for the script.
The Problem I Need Help With (The Blocker):
The crucial final step for the SP-API authorization flow is to configure the REDIRECT_URI within my app's Security Profile settings in Amazon Seller Central. Specifically, it needs to be added under 'Web Settings' > 'Allowed Return URLs'.
I am unable to find where to manage or edit these 'Web Settings' for my app's Security Profile within the Amazon Seller Central Developer Central interface. I've tried all the obvious clickable options (app name, 'Edit App', 'View LWA Credentials', 'View profile'), but none lead to the correct place to set the REDIRECT_URI. My app currently has a 'Draft' status in Developer Central.
What I need the freelancer to do:
Help me locate and add my REDIRECT_URI to my "Google Sheets" app's Security Profile in Amazon Seller Central Developer Central.
Confirm that the authorization flow works by helping me run the authAmazon() function from my Google Sheet.
Help me initiate the first data sync using syncAmazonOrdersToSheet() to ensure everything is connected and working.
I'm prepared to provide secure access to my Google Apps Script project, Amazon Seller Central, and AWS IAM credentials once we agree to work together.
I'm looking for a freelancer experienced with Amazon SP-API integration using Google Apps Script.
Project Goal:
I need to set up a custom solution to automatically pull my Amazon Seller Central sales order data via the Selling Partner API (SP-API) and sync it into a Google Sheet.
What I've already done/My current setup:
Google Apps Script: I have a Google Apps Script already written and deployed as a web app. It's designed to fetch Amazon orders and populate them into a Google Sheet.
I have my Google Apps Script Web App URL (this acts as my REDIRECT_URI).
My Google Sheet ID is set, and the destination tab name is 'Sales Order'.
Amazon SP-API App: I have registered a private SP-API application in my Amazon Seller Central Developer Central account.
I have my App Name, App ID, LWA Client ID, and LWA Client Secret.
AWS IAM User: I have created an AWS IAM user with programmatic access and assigned the necessary policies to generate Access Key and Secret Key for the script.
The Problem I Need Help With (The Blocker):
The crucial final step for the SP-API authorization flow is to configure the REDIRECT_URI within my app's Security Profile settings in Amazon Seller Central. Specifically, it needs to be added under 'Web Settings' > 'Allowed Return URLs'.
I am unable to find where to manage or edit these 'Web Settings' for my app's Security Profile within the Amazon Seller Central Developer Central interface. I've tried all the obvious clickable options (app name, 'Edit App', 'View LWA Credentials', 'View profile'), but none lead to the correct place to set the REDIRECT_URI. My app currently has a 'Draft' status in Developer Central.
What I need the freelancer to do:
Help me locate and add my REDIRECT_URI to my "Google Sheets" app's Security Profile in Amazon Seller Central Developer Central.
Confirm that the authorization flow works by helping me run the authAmazon() function from my Google Sheet.
Help me initiate the first data sync using syncAmazonOrdersToSheet() to ensure everything is connected and working.
I'm prepared to provide secure access to my Google Apps Script project, Amazon Seller Central, and AWS IAM credentials once we agree to work together.