Getting Started with Google Sheets in SellerAmp SAS

Getting Started with Google Sheets

Connecting Google to SAS

  1. In the web app (sas.selleramp.com), visit Sheets/Setup
    Google Sheets Setup button in SellerAmp SAS
  2. Connect your Google account. SAS will ask for your details. On the Google side you will have to give SAS permission/acknowledge it.
    Google Account selection page for SellerAmp Google Sheets integration
    Google sign-in verification page for SellerAmp Google Sheets integration
    Data access authorisation page for SellerAmp Google Sheets integration


Creating your Sheet in SAS

  1. Return to SAS to create a new worksheet by clicking 'New Sheet' - note that changes will autosave as you go along
    'New Sheet' selection in SellerAmp SAS Google Sheets sectionNew sheet configuration in SellerAmp SAS Google Sheets section
    1. Title - if you change this field in the future, ensure you manually change the Google sheet name
    2. Google Sheet Name - this will pre-populate with whatever SAS has created as the default name and can be changed manually in the sheet later
    3. Google Sheet ID - This will automatically populate
    4. Tab Name - By default, this will be Sheet1 - once you have renamed the tabs in the sheet, you can click 'Refresh Sheet Name & Tabs' and this will update the dropdowns.
    5. Field Mappings - Select, delete and arrange the fields you would like in your sheet here. You can add fields in the future (but they won't be able to get the data for information you have published in the sheet already)
    6. Undo Changes - if you have made any changes from the default on entering this menu, you can undo them here
    7. ‘Test & Write Headers' - This will create the header row in the spreadsheet (you can do this at any time – but it will be added to the bottom of your sheet
    8. Add - Add fields to be mapped to the sheet
    9. Back - Go back to the main Google Sheets menu in SAS
  2. Ensure, in your Settings, that the Google Sheets panel is turned on
    SellerAmp SAS Google Sheets panel toggle
  3. As you analyse products, you will now have the option to export to any one of the sheets you created in the Google Sheets panel
  4. If you're new to this product, you can watch our video on Google Sheets to learn more.