You can use Power Bi API to get the data and use Smartsheet API to add into the SmartSheet
Want to learn more about Power Bi, Refer & learn Power bi
Check out our Power BI Course to have a complete grip on Power BI concepts.
Also, check out our YouTube video to know the data visualization basics and best practices with Power BI