Without using the API directly, you'd need some third party service to handle those calls for you.
Zapier has good Smartsheet integrations that can perform this task. https://zapier.com/app/editor/template/2558
Another is automate.io, though I have no experience with them: https://automate.io/integration/google-sheets/smartsheet
