You can add items you have sourced or want to reference later to a Google Sheets spreadsheet without ever needing to leave ScoutX.
In this Guide:
Settings
To start using ScoutX with Google Sheets, the feature must be turned on in Settings and your Google account must be connected.
Turning Google Sheets On
To manage your Google Sheets settings, take the following steps:
1. Click the gear icon in the ScoutX display.
Note: This icon is available when viewing a product's detail page on Amazon.com
2. Navigate to Alerts & Integrations.
3. Click the Good Sheets toggle to change it to On.
With the feature turned On, you will see a Google Sheets icon in the ScoutX display.
Connecting Your Google Account
To connect your Google Account to ScoutX, take the following steps:
1. Click the Google Sheets icon.
2. Click Connect.
A new window will open where you can enter the credentials for your Google Account.
3. Enter the email address (or phone number) for your account.
4. Click Next.
5. Enter the password.
6. Click Next to proceed.
7. Click allow to proceed. This will allow ScoutX to access your Google account in order to create spreadsheets.
The window will close, and you'll see that ScoutX has updated to show that your Google account is connected.
You can switch Google accounts or disconnect them from ScoutX anytime by clicking the three vertical dots next to the Google account name.
For information on connecting and managing third-party apps with your Google account, please see- Manage your account permissions.
Creating and Managing Spreadsheets
To create a new spreadsheet, take the following steps:
1. Click the Google Sheets icon.
2. Locate the text box under Spreadsheets.
3. Enter the name of your new spreadsheet
4. Click the + (plus) icon in the text box next to Spreadsheets.
A new window will open where you can customize your new spreadsheet.
Title- The name of the spreadsheet. It can be edited within this field as needed.
Active Sheet - The specific sheet within the spreadsheet that items will be added to.
Sheets
When creating a new spreadsheet, Sheet1 is the Active Sheet by default.
Editing Sheets
1. Click the pencil icon to edit the name of the sheet.
2. Make your changes/edits.
3. Click the checkmark icon after making changes.
Adding Sheets
1. Click the + (plus) icon to add additional sheets.
2. Enter a name for the new sheet.
3. Click the checkmark icon to save it.
Once the spreadsheet has been created, you will see the sheets separated as tabs when viewing it in Google Sheets.
If you have added more than one sheet to a spreadsheet, click the dropdown arrow to select the Active Sheet in ScoutX.
Note: If you manually add a new sheet to a spreadsheet in Google Sheets, it will be available to select as an Active sheet in ScoutX as well.
Columns
You can choose to include the following columns in your spreadsheets:
Product Title
Product Image
ASIN
List Price
Buy Cost
Item Notes
Rank
Dimensions
Weight
UPC
Size Tier
FBA Offers
FBA Net Profit
FBA ROI
FBA Margin
MFN Offers
MFN Net Profit
MFN ROI
MFN Margin
Custom Columns (if created)
When creating a new spreadsheet, the following columns are included by default:
Product Title
Product Image
ASIN
List Price
Buy Cost
Item Notes
Editing your Columns
Drag and drop options under Available Columns into the Included Columns area to add them to your sheet.
Drag and drop options under Included Columns to the Available Columns area to exclude them from the sheet.
To change the order of the columns on the sheet, drag and drop the options under Included Columns into the desired order.
To include all available columns, click the right-facing arrow.
To remove all included columns, click the left-facing arrow.
Note: At least one included column is required.
Once you've made your selections, click Save.
You will see your new spreadsheet listed within ScoutX, and in Google Sheets.
When viewing the spreadsheet in Google Sheets, the column order will match the order of the options in the Included Columns area.
Add Custom Columns
Under the Included Column section is an option to Add Custom Column.
1. Click the Add Custom Column+
2. Add the name of a new column
3. Tap Enter/Return on your keyboard when done to save it.
Column names can be up to 40 characters long.
Delete Custom Column
1. Click the custom column.
2. Click the Trash Can icon.
3. Click Ok to proceed.
You can also manage your Custom Columns in Settings- ScoutX: Settings
Managing Spreadsheets
Once you have created spreadsheets using ScoutX, you will see them listed with the following information and options.
Active - Active spreadsheets will be available to add items to in ScoutX. A green toggle means it is Active, but you can click it to turn grey if you do not want to add items to it at the moment.
Note: Spreadsheets created outside of ScoutX will not be available to select as Active.
Spreadsheet Title - Clicking the titles of the spreadsheets will open them in Google Sheets.
Actions- Click the pencil icon to edit the spreadsheet or the unlink icon to unlink it to ScoutX.
Click the pencil icon to open a window to edit the title, add/edit sheets, and change the included columns.
Click Save to proceed with the changes.
Important Reminders when editing spreadsheets:
If you edit the columns for an existing sheet, the updated column headers will populate after the existing information in the sheet.
If columns are added, there is no way to automatically populate the data for the new columns for items that were previously added. To do this, you can manually delete the items from the sheet in Google Sheets and add them again.
If you attempt to edit a spreadsheet in ScoutX that you have removed from Google Sheets, you will see the option to Take it out of the Trash. (Currently, Google sheets will permanently delete spreadsheets in the trash after 30 days.)
Clicking the unlink icon will permanently delete it from ScoutX. This means that while the spreadsheet will still be available in Google Sheets, it will no longer be accessible by ScoutX.
You will be asked if you are sure you want to unlink the spreadsheet permanently. Click Unlink Spreadsheet to proceed.
Adding Items to a Spreadsheet
Before adding an item to a spreadsheet, make sure you have created a spreadsheet and have it set to Active in ScoutX.
Note: If the Active spreadsheet has more than one sheet, make sure the sheet you are wanting to add items to is selected as the Active Sheet.
1. Find an item you would like to add
2. Click Add Item
3. Select the Spreadsheet under the Add to Google Sheets section.
If any Custom Columns are included in the sheet, you will be asked if you want to add information in them for the item. They can also be left blank so the information can be entered later in Google Sheets.
4. Enter the information
5. Click Submit or Next: Add Note to save it.
Click Skip Note to bypass adding one.
If the Item Notes column is included in the sheet, you will be asked if you want to add a note for the item.
6. Enter the note
7. Click Submit to save or click Skip Note to bypass adding one.
The item will then be added to the sheet.
If the Item Notes column is not included in the sheet, you will not be asked to add a note, and the item will be added to the sheet right away.
In Google Sheets, the item will be added to the Active Sheet of the spreadsheet chosen.
If an item/row needs to be edited or removed from a sheet, this can be done manually in Google Sheets.
For information on editing spreadsheets directly in Google Sheets, please refer to their documentation- Google Docs Editors Help - Google Sheets
What's next?
Having trouble loading your spreadsheet? Check out Google Spreadsheet Created From ScoutX Won't Load