Automate Your Amazon Seller Central Workflow Using N8n and Google Sheets

Connecting Google Sheets

• In the N8n UI, click the “Add Persistent Credential” button again.
• Select the “Google Sheets” node.
• Enter a name to identify the Google Sheets connection.
• Click “Create Persistent Credential” to authenticate with Google Sheets.
• Grant N8n access to read, write, and modify the spreadsheet you want to connect.

With the API credentials configured for Amazon Seller Central and Google Sheets, you can now build an N8n workflow to automatically transfer your Amazon Seller Central data to a Google Sheet for enhanced reporting and analytics. Let N8n do the tedious data transfer work for you so you can focus on growing your business.

‍

Setting Up API Credentials for Amazon Seller Central

To connect your Amazon Seller Central account to N8n and Google Sheets, you will need to generate API access credentials within Amazon Seller Central. Follow these steps:

1. Log in to Seller Central and go to Settings → Developer settings. Click the "Register new developer" button.
2. Enter an App name, choose "Third-party app access" as the App type, and click "Register App". This will generate a Login with Amazon (LWA) Client ID and Client Secret.
3. Under "API Access", check the box next to "Manage your orders and shipments" and click "Generate Access Key". This will generate an Access Key ID and Secret Access Key.
4. Note down the LWA Client ID and Secret as well as the Access Key ID and Secret Access Key. These credentials will be used to authenticate the Amazon Seller Central node in your N8n workflow.
5. In N8n, activate the Amazon Seller Central node. For the authentication method, select "Access Keys". Enter the Access Key ID and Secret Access Key you generated.
6. For the LWA App ID and App Secret, enter the LWA Client ID and Client Secret. This authorizes N8n to access your Amazon Seller Central data.
7. Select the data you want to transfer to Google Sheets, such as order IDs, order dates or shipment statuses. Map the fields between Amazon Seller Central and Google Sheets.
8. Activate the Google Sheets node and enter your Google account credentials to authorize access. Select the spreadsheet you want to write the data to.
9. Run the workflow and your Amazon Seller Central data will be automatically transferred to the specified Google Sheet, streamlining your workflow and saving valuable time. Let N8n do the repetitive work for you!

Adding the Google Sheets Node to Your N8n Workflow

‍

Adding the Google Sheets Node

To transfer your Amazon Seller Central data to Google Sheets, you'll need to add the Google Sheets node to your N8n workflow.

Follow these steps:

1. Install the Google Sheets node in your N8n instance. This can be done by searching for “Google Sheets” in the node installer and clicking install.
2. Create a Google Sheets spreadsheet in your Google Drive account to hold the data from Amazon Seller Central. Give the spreadsheet a name like “Amazon Seller Central Data”.
3. Generate API credentials for Google Sheets in the Google Cloud Console. This will provide you with a Client ID and Client Secret to authorize the Google Sheets node in your N8n workflow.
4. Add the Google Sheets node to your N8n workflow and configure it with the Client ID and Client Secret from the previous step. This will authorize N8n to access your Google Sheets account.
5. Select the spreadsheet you created in Step 2 from the list of spreadsheets in your Google Drive. The node will default to the first sheet in the spreadsheet, named “Sheet1”. You can rename this to something like “Orders” or “Products” depending on your use case.
6. Map the data from the Amazon Seller Central node to the appropriate columns in your Google Sheets spreadsheet using N8n’s mapping interface. For example, map “Order ID” to column A, “Product Name” to column B, “Price” to column C, and so on.
7. Run your N8n workflow and the data from Amazon Seller Central will be transferred to the mapped columns in your Google Sheets spreadsheet.
8. Check your Google Sheets spreadsheet to ensure the data was mapped and transferred accurately. Make any necessary adjustments to your N8n workflow.

By following these steps, you'll have an automated way to sync your Amazon Seller Central data with Google Sheets for reporting, analysis and monitoring your store's sales and products. Let me know if you have any other questions!

Configuring API Credentials for Google Sheets

To connect your Amazon Seller Central account to N8n and export data to Google Sheets, you will need to configure API credentials for Google Sheets. Follow these steps to obtain the necessary credentials:

Generate a Service Account

1. Go to the Google Cloud Console and select the project that contains the Google Sheet you want to access.
2. Click APIs & Services > Credentials.
3. Click Create credentials > Service account.
4. Enter a name for the service account and select "Project" > "Editor" as the role.
5. Click Create. Your service account credentials will be created and downloaded to your machine.

Enable the Google Sheets API

1. In the Google Cloud Console, select your project.
2. Click APIs & Services > Library.
3. Search for and select the Google Sheets API.
4. Click Enable. The Google Sheets API will now be enabled for your project.

Add Service Account Credentials to N8n

1. Open N8n and go to Workflow > Auth Credentials > Add credentials.
2. Select "Google" as the credential type.
3. Name your credentials and select "Service Account".
4. Upload the JSON file you downloaded for your service account.
5. The credentials will be added. You can now use the "Google Sheets" node in your workflows.

Share the Google Sheet with your Service Account

1. Open the Google Sheet you want to access.
2. Click Share.
3. Enter the email address of your service account in the "Add people and groups" field. This will be the "client_email" value in the JSON credentials file.
4. Change the access level to "Editor" and click Send.
5. Your service account now has edit access to the Google Sheet.

With the API enabled and credentials configured, you can now build an N8n workflow to automatically transfer data from your Amazon Seller Central account to a Google Sheet. Please let me know if you have any other questions!

Mapping Data and Running Your Workflow

‍

To transfer your Amazon Seller Central data to Google Sheets, you must map the data fields between the two services to define how information should flow from one to the other.

Connecting the Nodes

The first step is connecting the Amazon Seller Central and Google Sheets nodes in your N8n workflow. Select the nodes and click the “Connect” button to create a connection between them.

Selecting Data Fields

Next, you need to choose which data fields to extract from Amazon Seller Central and import into Google Sheets. In the Amazon Seller Central node, select fields like “Product ID,” “Product Name,” “Price,” “Inventory,” and “Sales Rank.” In the Google Sheets node, map those fields to corresponding columns in your spreadsheet.

Configuring the Workflow

With the nodes connected and fields mapped, you must configure a few final settings in the workflow.

• In the Amazon Seller Central node, enter your Seller Central API credentials to authorize access.
• In the Google Sheets node, select the spreadsheet and worksheet you want to send the data to. Authorize access to your Google account.
• Set a schedule to automatically run the workflow and keep your data up to date. You can run it every few hours, once a day, or a few times per week depending on your needs.
• Test the workflow to ensure data is transferring accurately before running it live. Check that the fields have mapped properly and information is populating in the right columns in your spreadsheet.
• Activate the workflow to start the automated data transfer process. Your Amazon Seller Central data will now sync to the specified Google Sheet on the schedule you defined.
• Monitor your workflow regularly to ensure there are no errors and data is being transferred as expected. Make any necessary adjustments to the field mappings or schedule as needed.

With some initial configuration, you can build an automated workflow to seamlessly transfer your Amazon Seller Central data to Google Sheets, keeping the information up to date and enabling you to analyze key metrics and optimize your business. Let me know if you have any other questions!

Conclusion

By connecting your Amazon Seller Central account to N8n and Google Sheets, you can automate the transfer of product data and save countless hours of manual data entry. With the workflow configured, your Amazon listings will automatically populate in Google Sheets where you can further organize and analyze the information. No longer will you need to manually export reports and copy and paste data between the two systems. Automating your Amazon Seller Central workflow using N8n and Google Sheets allows you to scale your business and focus your time on more important initiatives to drive growth. The possibilities are endless when you unlock the power of automation.

‍