I would think that you would just want to download each table as a .csv file. This download option is available after next to the down arrow on the name for each table.
You can then paste the downloaded data into each tab of your google sheet. The formulas within the Airtable and other connections will have be to reestablished as google sheets operates quite a bit differently than Airtable.