How to see all of a competitor's Google, Meta and TikTok ads in one spreadsheet

Search the Google Ads Transparency Center, Meta Ad Library and TikTok Ad Library by domain or brand name and get every ad back in one table.