# Google Sheets

### Configuration

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

Connect to Google Sheets via oAuth:

<figure><img src="https://2845823711-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FtvRVifvxmkDBmPKpGlr2%2Fuploads%2F40w5huM2rrm6pkBsni0o%2Fgoogle%20oauth.png?alt=media&#x26;token=07ea94aa-2062-4bdd-882c-6e633350a404" 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="https://2845823711-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FtvRVifvxmkDBmPKpGlr2%2Fuploads%2FpcpU4GD7O3rfM9TsrGye%2Fimage.png?alt=media&#x26;token=df7055ea-6286-4eb2-b209-6af8c620b4e6" alt=""><figcaption></figcaption></figure>

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

{% hint style="info" %}
You can use [Wildcard Filenames](https://help.dataimporter.io/jobs/wildcard-names) 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="https://2845823711-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FtvRVifvxmkDBmPKpGlr2%2Fuploads%2FLVnKVbhuiZlQXVRqdCYQ%2Fimage.png?alt=media&#x26;token=182039b5-4c70-4cda-8214-e34d73149980" alt=""><figcaption></figcaption></figure>