SIGN UP FOR FREE<\/a><\/div>\n<\/div>\n
<\/div>\n
[\/et_pb_code][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Step 2: Designate a folder for flat files<\/h4>\n
Next, you want to import all of your Amazon data into spreadsheets to create flat files. Then, add them all to a single folder.<\/p>\n
You will use this to merge these files into a single spreadsheet.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Step 3: Create a new workflow<\/h4>\n
On the homepage of the Sheetgo web app, click on + New workflow<\/b>.<\/p>\n
From the Explore page, where it says From New connection<\/b>, click on Create connection<\/b>.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/11\/Amazon-price-tracker-4.png” alt=”Amazon price tracker 4″ title_text=”Amazon price tracker – 4″ align=”center” _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Step 4: Add your source folder<\/h4>\n
You will be asked to select a source for the data.<\/p>\n
Choose the Files in a folder<\/b> option.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/11\/Amazon-price-tracker-6.png” alt=”Price tracker 6″ title_text=”Price tracker – 6″ align=”center” _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Click on + Select folder<\/b> to browse your folders. You can select a folder from online drives like Google Drive, OneDrive, Dropbox, etc.<\/p>\n
Choose the folder where you added all of your flat files.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/11\/Amazon-price-tracker-7.png” alt=”Price tracker 7″ title_text=”Price tracker – 7″ align=”center” _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Once you have selected the folder, click on Settings<\/b> at the bottom to expand the options.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/11\/Amazon-price-tracker-8.png” alt=”Amazon price tracker 8″ title_text=”Amazon price tracker – 8″ align=”center” _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Step 5: Identify the source<\/h4>\n
In the extended settings area, under Identify Data<\/b>, activate the Add new column<\/b> button to keep track of the original source file.<\/p>\n
You can choose how to identify the data from a dropdown list, including source file location, source file name, and source tab name.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/11\/Amazon-price-tracker-9.png” alt=”Amazon price tracker 9″ title_text=”Amazon price tracker – 9″ align=”center” _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Once finished, click Next<\/b>.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Step 6: Merge files<\/h4>\n
Under the Process<\/b> section, click on Merge<\/b>.<\/b><\/b>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/11\/Amazon-price-tracker-10.png” alt=”Amazon price tracker 10″ title_text=”Amazon price tracker – 10″ align=”center” _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
This will combine all of your flat files into a single spreadsheet.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Step 7: Choose a destination file<\/h4>\n
Now it\u2019s time to choose where your combined data will be stored. Under the Send to<\/b> section, select to send your data to a Single file<\/b>.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/11\/Amazon-price-tracker-11.png” alt=”Amazon price tracker 11″ title_text=”Amazon price tracker – 11″ align=”center” _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Here, you can choose whether to send the merged data to a new or existing spreadsheet.<\/p>\n
Here, I will create a new file for my data. Create a new file name and file tab name.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/11\/Amazon-price-tracker-12.png” alt=”Amazon price tracker 12″ title_text=”Amazon price tracker – 12″ align=”center” _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Once finished, complete your workflow by clicking Finish and save<\/b>.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Step 8: Run the workflow<\/h4>\n
Now that your workflow is complete, it\u2019s time to run the connections to update your new spreadsheet with all the data.<\/p>\n
Click on the Workflow<\/b> menu, and select Run<\/b> in the bottom-left corner.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/11\/Amazon-price-tracker-13.png” alt=”Amazon price tracker 13″ title_text=”Amazon price tracker – 13″ align=”center” _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Step 9: Open your file and filter your data<\/h4>\n
In the merged file, you can add as many filters and conditions as you need to focus on different aspects of the data.<\/p>\n
Customize your spreadsheet to provide you with the exact data points you need to carry out your pricing strategy.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/11\/Amazon-price-tracker-14.png” alt=”Amazon price tracker 14″ title_text=”Amazon price tracker – 14″ align=”center” _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
And there you have it! Using the top price tracking tools and the Amazon Seller Central<\/a>, you can get all the pricing data you need as flat files, in order to position your own prices at a competitive edge. By using Sheetgo to merge and filter these flat files, you can have access to all your information in one place, whilst also having direct references to all of your original sources.<\/p>\nLooking for a way to help monitor your Amazon product inventory? Why not check out our article on how to create an automated Inventory management template in Google Sheets?<\/a>Alternatively, take a look at some of the related blog posts below!<\/p>\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"
Amazon has come a very long way in terms of its product offer. By now, it has a very wide selection of products, including pretty much anything you can think of. It\u2019s also a great way for third-party sellers to offer both new and used versions of many of these products. That\u2019s where Amazon price […]<\/p>\n","protected":false},"author":40,"featured_media":41505,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[33],"tags":[],"class_list":["post-41458","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-how-to-solve-with-sheetgo"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/41458","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=41458"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/41458\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/41505"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=41458"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=41458"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=41458"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2020\/08\/banner-logo-light.svg\"){kind=logo}
<\/div>\n![](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/09\/sheetgo-banner-rating-2m.svg\")
<\/div>\n