๐Ÿ“€FTP, Google Drive, and Google Sheets

Learn how to connect your Report Pundit account to various file transfer options

Configure your automated report delivery settings here by entering the required connectivity details to your FTP, Google Drive, and other destinations.

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.

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.

  1. Enter the FTP account credentials. Private Key entry is optional.

  1. Select the directory where you want to receive and store the reports, and enter the port number.

Note: Kindly contact us if you want to connect through a port other than 21 or 22.

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.

  1. 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, 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. 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:

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'.

  1. 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.

That's it! You've now successfully connected your Google Drive/Sheets account.

Learn more about scheduling to Google Drive and Sheets by clicking on the respective tabs:

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.

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.

Contact our support team if you need any help regarding these connectivity options.

Last updated