How do you export a Google Sheet with all the necessary tabs, as seen here: https://supermetrics.com/blog/facebook-ads-data-studio
I can't find detailed instructions on the boxes I should be checking to retrieve all that information that's presented.
I'm not clear where the issue is - can you describe which step or part of the blog post you are getting stuck at and what isn't working as described?
None of the instructions reference an Excel document, so perhaps that is the issue? You need to use Google Sheets to perform the steps in the blog post - and it cannot be an Excel file type, but a Google Sheets file specifically.
You can also avoid using the spreadsheet completely and use the Facebook Ads connector in Data studio to pull right from the source (the blog post may have been created before we had this option). See this article for instructions and an example video of how to do this:
Please let me know if you need any further assistance.