# FTP, Google Drive, and Google Sheets
Configure your automated report delivery settings here by entering the required connectivity details to your FTP, Google Drive, and other destinations.
### :clipboard: Steps to Connect with FTP
To connect FTP and store reports, follow these steps:
1. Go to the '**Settings**' page and open the '**FTP & Google Drive'** section from the sidebar on the left.
2. Click on '**Connect**' to access the FTP option.
{% hint style="warning" %}
Allow the IP address shown in the notification if you're using a firewall or private network for your store database to let Report Pundit access it.
{% endhint %}
3. Enter the FTP account credentials**.** Private Key entry is optional**.**
4. Select the directory where you want to receive and store the reports, and enter the port number.
{% hint style="info" %}
**Note:** Kindly [contact us](https://www.reportpundit.com/contact-us) if you want to connect through a port other than **21** or **22.**
{% endhint %}
**Passive Mode:** It is enabled by **default** and we recommend switching to it permanently to resolve any issues. Ask your service provider to set up the FTP to accept the connection in passive mode. You can learn more about passive mode by clicking [here](https://dayspring-tech.gitbook.io/report-pundit/kb/knowledgebase-intro/schedules/output-options/ftp#steps-to-schedule-any-report-through-ftp).
5. Select a **connection mode** and click on the '**Test Connection'** button. If the result is '**Success**', click on '**Save and Update'.**
If the result is '**Failed'** or anything else**,** it could be due to many reasons:
* You might have to **whitelist** Report Pundit's IP Address
* Public IP: **54.245.198.171**
* Private IP: **172.31.10.79**
* You might have chosen the **wrong directory path.**
* You might have chosen a different **Port Number,** apart from **20** or **21.**
* You might have typed an **incorrect password.**
If you still can't connect, kindly [**contact us**,](https://www.reportpundit.com/contact-us) and we'll help you set it up.
### Passive Mode
Passive Mode is the **recommended connection** mode for FTP. In Passive Mode, the FTP client still **initiates a command** channel connection to the **server**. However, instead of **sending** the **PORT** command, it sends the **passive command**, which is a **request** to connect a server port for **data transmission**. When the FTP server replies, it indicates the **PORT number** it has opened for the data transfer. \
\
\&#xNAN;*Here's how passive mode works in a nutshell:*
1. The FTP client connects from a random port to port 21 on the server and issues the **PASV command**.
2. The server replies, indicating which (random) port it has opened for data transfer.
3. The FTP client connects from another random port to the random port specified in the server's response.
4. Once the connection is established, data transfers are made through these client and server ports.
Learn more about FTP connectivity by clicking on the tab below:
{% content-ref url="../../knowledge-base/schedules/output-options/ftp" %}
[ftp](https://docs.reportpundit.com/knowledge-base/schedules/output-options/ftp)
{% endcontent-ref %}
### Steps to Connect with Google Drive and Google Sheets:
1. Go to the **Settings** page and click the **'FTP & Google Drive'** option in the left side panel.
2. Under the Google Drive section, click on **'Connect'**.
3. Select the Google account to be integrated and grant permission to Report Pundit by clicking on '**Allow'.**
Once connected, you get the following screen:
1. **Connect Another:** Click this button to connect another Google account to your Report Pundit account.
2. The Google account currently connected to your Report Pundit account.
3. **Revoke:** Click this button to remove the currently connected Google account.
{% hint style="success" %}
That's it! You've now successfully connected your Google Drive/Sheets account.
{% endhint %}
Learn more about scheduling to Google Drive and Sheets by clicking on the respective tabs:
{% content-ref url="../../knowledge-base/schedules/output-options/google-drive" %}
[google-drive](https://docs.reportpundit.com/knowledge-base/schedules/output-options/google-drive)
{% endcontent-ref %}
{% content-ref url="../../knowledge-base/schedules/output-options/google-sheets" %}
[google-sheets](https://docs.reportpundit.com/knowledge-base/schedules/output-options/google-sheets)
{% endcontent-ref %}
### Big Query
You can connect with Google's Big Query service and send your Report Pundit data directly there. Find more details on how to connect in our dedicated Big Query help page by clicking on the tab below.
{% content-ref url="../../knowledge-base/schedules/output-options/bigquery" %}
[bigquery](https://docs.reportpundit.com/knowledge-base/schedules/output-options/bigquery)
{% endcontent-ref %}
### Power BI
Microsoft's Power BI is a data visualization tool that can collect your raw Shopify store data and provide business intelligence through captivating graphical representations.
You can find details on how to connect your Report Pundit to your Power BI account by clicking on the tab below.
{% content-ref url="../../knowledge-base/schedules/output-options/power-bi" %}
[power-bi](https://docs.reportpundit.com/knowledge-base/schedules/output-options/power-bi)
{% endcontent-ref %}
{% hint style="info" %}
[Contact our support team](https://www.reportpundit.com/contact-us) if you need any help regarding these connectivity options.
{% endhint %}
