GiveWP – How to Import Donation Forms from Google Sheets

In this tutorial, we will show you how to import GiveWP donation forms from Google Sheets. We’ll easily connect our WordPress site to our Google account, and then we’ll be able to create and edit donation forms from Google Sheets.

Related tutorial: How to Export Donation Forms to Google Sheets

We will use two important elements to be able to import donation forms from Google Sheets.

WP Sheet Editor – GiveWP

With this plugin, you can view and manage your GiveWP donation forms, donor profiles, and donations using an intuitive spreadsheet inside WordPress. You can run advanced searches, bulk edit hundreds of items at once, export and import data using CSV files.

Google Sheets Sync service, provided by wpsheeteditor.com

This service allows you to connect your WordPress site to your Google account, in order to export and import data between WordPress and Google Sheets.

This service works with all the WP Sheet Editor spreadsheets, so you can export and import any post type or taxonomy, including custom fields added by third-party plugins.

1- Connect WordPress to Google Sheets

When you sign up to the Google Sheets Sync service, you’ll get a helper plugin that will allow you to connect your WordPress site to your Google account, the Google API, and the WP Sheet Editor API.

You can follow this guide to learn how to sync WordPress to Google Sheets.

2- Create or edit GiveWP forms in Google Sheets

You need to first prepare the data you will import from Google Sheets into WordPress.

Something to keep in mind:

• To protect your privacy, our Google Sheets Sync service doesn’t read files that have not been created with the service itself.
• In other words, the service doesn’t recognize files that were not first exported from WordPress to Google Sheets using the same service.
• This means that we don’t have any access to other files on your Google account; not even to other Google Sheets files.
• To import a Google Sheets file, you’ll need to first export the info. Once you’ve exported it, you can edit existing data or create new data by adding new rows in Google Sheets.

Here’s a tutorial on how to export GiveWP forms to Google Sheets.

You need to have a Google Sheets file like the one we show you below:

2- Import GiveWP forms from Google Sheets

Go to WP Sheet Editor > Edit Donation Forms. You’ll see all your GiveWP donation forms displayed in the spreadsheet.

Now you need to click on Import on the top toolbar.

Next, you need to select the Google Sheets file you want to import:

• Source: Google Sheets
• Google Sheet File: Select the file you’ll import. If you don’t find it, you can click on the Refresh list button.
• Click on Next.

Now you need to select the columns you want to import.

You have two options:

1. Import all the columns
2. Select individual columns to import

Now you need to match the rows in the Google Sheets file with the information on WordPress.

For this, you need to use a specific field as an identifier.

In this case, it’s best to use the ID field.

Click on Next.

Now you’ll see a preview of what the info will look like once it’s imported.

If everything is OK, you can click on The preview is fine, start import.

You will start importing the GiveWP forms data by following these steps.

In this tutorial, you’ve learned how to import GiveWP forms from Google Sheets to WordPress.

With the Google Sheets Sync service, you can connect your WordPress site to your Google account to export and import GiveWP forms, donor profiles, or donations.