Export Airtable to Google Sheets

In today's data-driven world, integrating your applications can streamline workflows and enhance productivity. CSV Getter is a powerful tool that enables you to easily export data from Airtable directly to Google Sheets. This step-by-step guide will walk you through how to setup an automated pipeline that keeps your Google Sheet updated with live Airtable data.

Step 1: Access CSV Getter Home

Begin by navigating to the CSV Getter Home. This is your starting point for all integrations.

Step 2: Connect to Airtable

1. Click on Data: Once you’re on the CSV Getter homepage, locate and click the "Data" option.

2. Select Airtable: Under the available options, click on "Connect" next to Airtable.

3. Add a Base: Airtable will prompt you to add a base. Click on "Add a base" to proceed.

4. Choose Base Access: Decide which bases you want CSV Getter to access. For this guide, we will select all bases for broader data availability.

5. Grant Access: Click on "Grant access" to allow CSV Getter to interact with your Airtable bases.

Step 3: Create an Export from Airtable

Now that you have connected your Airtable account, you can create an export.

1. Go to CSV Getter Home: Return to the CSV Getter home page.

2. Create Export: Click on "Create Export" to initiate the process.

3. Select Data Source: You will be prompted to select a data source. Click on "Select Data Source."

4. Choose Airtable: From the list of data sources, select "Airtable."

5. Select Your Base, Table, and View: Choose the specific base, table, and view you want to export.

6. Name Your Export: Enter a name for your export to easily identify it later.

7. Submit the Export: Click on "Submit" to proceed with your export.

8. Review Your Data: On the Sample screen, you can customise your export by removing fields or adjusting the column order.

9. Export Instantly: If you need an immediate CSV version of your data, press "Export Now" for instant access.

10. Copy Automated Export URL: For future automated exports, click the clipboard icon to copy the URL for seamless access.

11. (Hint) Download Latest Export: Remember, you can always download your latest export from the Exports page.

Step 4: Exporting to Google Sheets

1. Sample Screen: Open the sample screen for your chosen export

2. Click on Spreadsheet Import: Select the "Spreadsheet Import" option.

3. Choose G Sheets: Click on "G Sheets" to prepare for Google Sheets integration.

4. Copy the Code: Click the clipboard icon to copy the provided code.

5. Open Google Sheets: In your Google Sheets document, click on "Extensions" in the menu bar.

6. Open Apps Script: From the dropdown, select "Apps Script."

7. Paste the Code: In the Code.gs file, paste the code you copied from CSV Getter.

8. Save Your Script: Don't forget to save your changes.

9. Test the Code: Click the Play Arrow to test the script and ensure it's working as expected.

10. Check Execution Log: After running the script, check the Execution Log to confirm it executed successfully.

11. Review Data in Google Sheets

Your Google Sheets will automatically update with the data exported from Airtable.

12. Set Up Scheduled Updates: To automate updates, navigate back to Apps Script and click on "Triggers."

13. Add a New Trigger: Click on "Add Trigger" to schedule updates.

14. Change Event Source: Alter the event source to "Time-driven" for scheduled execution.

15. Save Your Trigger: Click "Save" to finalise the scheduled updates.

16. Enjoy Scheduled Backups: Your sheet is now set to receive regular updates automatically, providing you with a robust backup of your data.

By following these steps, you can efficiently export data from Airtable to Google Sheets using CSV Getter. This integration allows for streamlined data management and automated updates, making it easier to keep track of your information. Start using CSV Getter today to take control of your data exports!

This guide was designed to ensure a smooth and efficient process for users at all skill levels. If you have any questions or run into issues, please reach out to info@csvgetter.com