Read/Write Smartsheet Data

Hello team,

I have done read/write data with excel scope app but I need to do the same in Smartsheet as well.
My requirement is that

  1. login to smartsheet
  2. search for page (Yes- Page found, No-Page not Available)
  3. Clear all filters and filter a specific status (only uncompleted tasks)
  4. Check from reference excel/pdf/any app for missing fields and update the same in smartsheet one row after another row

Please suggest how to do the same.

Thanks in Advance