Generally, Tableau can schedule reports to be refreshed in Tableau Online or Tableau Server (usually used in larger corporations), however there are some limitations of the refreshing web connectors.
Unfortunately, Tableau Online does not support web connector refreshing, so this cannot be used to refresh the Supermetrics API connections. The report can be published and shared with others in the Online version, but data will need to be manually refreshed from the Desktop version to update the reports.
Tableau Server can refresh web connectors, but some configuration steps are required to set this up. See this article for more details: