You can use Awesome Table Connectors to export data from Facebook Ads to Google Sheets by logging in with the Facebook Ads connector.
In the Awesome Table add-on Home screen, click Create new request.
The list of available connectors is displayed.
Open the Facebook Ads connector.
On the Connect to Facebook Ads screen, click Login with Facebook.
Log in to Facebook with your account.
Click Done to grant Awesome Table permissions.Awesome Table informs you if your connection is successful.