Getting Started with Google Sheets in SellerAmp SAS

Getting Started with Google Sheets

  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
  3. 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
  4. Ensure, in your Settings, that the Google Sheets panel is turned on
    SellerAmp SAS Google Sheets panel toggle
  5. As you analyze, in the Google Sheets panel you will then have the option to export to any one of the sheets you created
  6. If you're new to this product, you can watch our video on Google Sheets to learn more. 

    • Related Articles

    • How do I connect my Google account to SAS?

      Click "Setup" in the Sheets dropdown Click "Connect Google Account" Select the Google account you wish to sync with SAS, and review the permissions access SellerAmp SAS requires to integrate with Google Sheets You should now be connected If you ...

    • I've connected the wrong Google account - how do I undo it?

      Click "Setup" in the Sheets dropdown Click "Disconnect" A confirmation message will show before you disconnect - note that disconnecting will not delete the Google Sheets created in SAS which are associated to the wrong account and will still be ...

    • Reconnecting SellerAmp to Google and Google to SAS

      If you receive an error saying "The caller does not have permission" or "Invalid Token Format" or if the export is not occurring, this could mean Google cannot find the spreadsheet you are trying to export to. Confirm the file is in your Google drive ...

    • Adding Google Sheets tabs for export

      Create a new tab in Google Sheets by clicking the plus sign , then rename the sheet accordingly Go back to SAS and select Sheets / Setup , Then click Edit next to the relevant sheet In the tabs section , select the new tab you created in Google ...

    • What do I need to get started with the ArbiSource integration?

      Alongside an active SAS subscription, you will need an Amazon Seller Central account and an active Arbisource subscription to use this integration. You can sign up for a free 14-day trial with Arbisource here. Check out this video about how the ...