How to get access token in Smartsheet


I have a my service account with email id , using that I have to get access token from Smartsheet to do more calls

Is there any API for that ?


  • Sameer Karkhanis
    Sameer Karkhanis ✭✭✭✭✭✭

    Login to SS. Click on your account icon on the left bottom corner. Select Personal Settings from the menu. Select API Access from left nav menu. Generate the access token.

  • natebi
    natebi ✭✭

    Hi I'm seeing a very limited number of sheet names when I use:

    smartsheet_client = smartsheet.Smartsheet([usersecret])
    response = smartsheet_client.Sheets.list_sheets()

    Then loop through[i].name and store the results in a list.

    How do I get the list of all sheet names that I have access to using the usual smartsheet UI?

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @natebi

    Two things to clarify here:

    1. List Sheets will only return a list of sheets that your specific account/email has been shared to, the ones you can see in the UI (it sounds like you already identified this!)
    2. The default page size with List Sheets is 100. If you only see 100 sheets being returned, check your page and page size