Hi Bob,
Thanks for reaching out. There isn't an Ads API-Sheets/Data Studio connector that I can point to, but I would recommend looking into the
Sheets API with Apps Scripts. For Data Studio related support, I would recommend reaching out on
this forum.
Thanks,
Matt
Google Ads API Team

ref:_00D1U1174p._5004Q2DwFep:ref