> For the complete documentation index, see [llms.txt](https://help.dataimporter.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.dataimporter.io/integrations/storage/google-sheets.md).

# Google Sheets

### Configuration

{% hint style="info" %}
You may need to whitelist the Dataimporter [IP Addresses](/security/ip-addresses.md)
{% endhint %}

Connect to Google Sheets via oAuth:

<figure><img src="/files/UUlOAx8ocjaktKGCKO3j" alt=""><figcaption></figcaption></figure>

### Import

On the Upload screen, you will have an interactive interface where you can navigate through your Folders and Sheets.

<figure><img src="/files/VZC3W4i5nD4STiRDdvIb" alt=""><figcaption></figcaption></figure>

Here you can also select which Sheet you wish to Import from.

{% hint style="info" %}
You can use [Wildcard Filenames](/jobs/wildcard-names.md) to select dynamic files
{% endhint %}

### Export

On the Upload screen you can enter the Path to the file that will be exported, as well as the Salesforce Object that you want to export from.

<figure><img src="/files/hqLAA3xkuLVKm3g5KYi1" alt=""><figcaption></figcaption></figure>