Alice – This may take a minute to run; it will return 10 reports where BDO, USA, LLP appears across multiple filings: /document/search?document.text-search=%22BDO,%20USA,%20LLP%22&fields=dts.id,document.limit(10),document.example,report.id,document.uri,document.id,report.filing-date.sort(DESC),entity.name
Google Sheets is not the best tool for this – you should have a client ID/secret pair and use a tool like postman or insomnia (Google stops queries that take longer than 60 seconds).