Migrate Smartsheet
This module provides plugins for Drupal's migrate system to import data from Smartsheet. It allows you to authenticate with the Smartsheet API and then process rows and columns from your sheets directly into Drupal.
This developer module extends the migrate process plugins to work specifically with the Smartsheet API.
When creating your migration .yml file, you must provide a Smartsheet API key. To keep your API key safe, I suggest using one of the tactics in this great lullabot article.
When making requests to the Smartsheet API, there are 2 JSON arrays used to grab the raw data in the sheet, 'rows' and 'columns.' Use the 'columns' array to look up each column's ID. Use the process plugin to iterate through each 'row' and return the data for a specified column ID.
Please read the README.txt file and the comments in Smartsheet.php for more information on how to use this process plugin.