Title: SFTP Sync for Google Sheets
Author: Olivier Bigras
Published: <strong>01.03.2026</strong>
Last modified: 31.08.2026

---

Шукати плагіни

![](https://ps.w.org/sftp-sync-for-google-sheets/assets/banner-772x250.png?rev=3507462)

![](https://ps.w.org/sftp-sync-for-google-sheets/assets/icon-256x256.png?rev=3507456)

# SFTP Sync for Google Sheets

 Від автора [Olivier Bigras](https://profiles.wordpress.org/bigrat95/)

[Завантажити](https://downloads.wordpress.org/plugin/sftp-sync-for-google-sheets.1.5.2.zip)

 * [Деталі](https://uk.wordpress.org/plugins/sftp-sync-for-google-sheets/#description)
 * [Відгуки](https://uk.wordpress.org/plugins/sftp-sync-for-google-sheets/#reviews)
 *  [Встановлення](https://uk.wordpress.org/plugins/sftp-sync-for-google-sheets/#installation)
 * [Розробка](https://uk.wordpress.org/plugins/sftp-sync-for-google-sheets/#developers)

 [Підтримка](https://wordpress.org/support/plugin/sftp-sync-for-google-sheets/)

## Опис

SFTP Sync for Google Sheets allows you to automatically export Google Sheets and
upload them to any SFTP server. Use cases include:

 * Daily inventory updates from Google Sheets
 * Automated data feeds for e-commerce
 * Syncing spreadsheet data to your server
 * Backing up Google Sheets to your own server

**Features:**

 * **Easy Setup** – Configure everything from the WordPress admin
 * **Secure API** – Auto-generated API keys protect your endpoint
 * **REST API Endpoint** – Receives files from Google Apps Script
 * **SFTP Upload** – Automatically uploads to your SFTP server
 * **Activity Logs** – Track all uploads and errors
 * **Pre-built Script** – Copy-paste Google Apps Script included
 * **No paid services required** – Uses Google Apps Script and your SFTP server

**How It Works:**

 1. Install and activate the plugin
 2. Configure your SFTP credentials in Settings
 3. Copy the provided Google Apps Script to your Sheet
 4. Set up a daily trigger in Google Apps Script
 5. Your sheet automatically syncs to your SFTP server

## Скріншоти

[⌊Plugin settings page with API endpoint information and SFTP server configuration⌉⌊
Plugin settings page with API endpoint information and SFTP server configuration⌉[

Plugin settings page with API endpoint information and SFTP server configuration

[⌊Export settings with schedule, filename mode, and format options⌉⌊Export settings
with schedule, filename mode, and format options⌉[

Export settings with schedule, filename mode, and format options

[⌊Activity logs and Google Apps Script code generator⌉⌊Activity logs and Google 
Apps Script code generator⌉[

Activity logs and Google Apps Script code generator

## Встановлення

 1. Upload the `sftp-sync-for-google-sheets` folder to `/wp-content/plugins/`
 2. Activate the plugin through the ‘Plugins’ menu in WordPress
 3. Go to Settings  SFTP Sync
 4. Enter your SFTP server credentials
 5. Click “Test SFTP Connection” to verify
 6. Copy the Google Apps Script from the settings page
 7. Paste into your Google Sheet (Extensions  Apps Script)
 8. Run `setupTrigger()` to enable daily exports

## Часті питання

### What SFTP libraries are supported?

The plugin supports both the PHP ssh2 extension and phpseclib. If neither is available,
you can install phpseclib via Composer.

### Are there any costs?

This solution uses Google Apps Script and your existing SFTP server. No third-party
paid services are required.

### Can I export as XLSX instead of CSV?

Yes! Change `EXPORT_FORMAT: 'csv'` to `EXPORT_FORMAT: 'xlsx'` in the Google Apps
Script configuration.

### How do I change the export schedule?

In the Google Apps Script, change `SCHEDULE: 'daily'` to `SCHEDULE: 'hourly'` for
hourly exports, or modify `DAILY_HOUR` to change the time.

### Is the API secure?

Yes. All requests require a valid API key. The key is auto-generated on activation
and can be regenerated anytime.

### Can I use this with multiple Google Sheets?

Yes! Each Google Sheet can have its own Apps Script. They can all point to the same
WordPress endpoint.

## Відгуки

Для цього плагіна немає відгуків.

## Учасники та розробники

“SFTP Sync for Google Sheets” — проект з відкритим вихідним кодом. В розвиток плагіну
внесли свій вклад наступні учасники:

Учасники

 *   [ Olivier Bigras ](https://profiles.wordpress.org/bigrat95/)

[Перекладіть “SFTP Sync for Google Sheets” на вашу мову.](https://translate.wordpress.org/projects/wp-plugins/sftp-sync-for-google-sheets)

### Цікавитесь розробкою?

[Перегляньте код](https://plugins.trac.wordpress.org/browser/sftp-sync-for-google-sheets/),
перегляньте [сховище SVN](https://plugins.svn.wordpress.org/sftp-sync-for-google-sheets/)
або підпишіться на [журнал розробки](https://plugins.trac.wordpress.org/log/sftp-sync-for-google-sheets/)
за допомогою [RSS](https://plugins.trac.wordpress.org/log/sftp-sync-for-google-sheets/?limit=100&mode=stop_on_copy&format=rss).

## Журнал змін

#### 1.5.2

 * Fixed Save Settings wiping the API key, which caused Google Apps Script exports
   to return 401 rest_forbidden
 * Google Apps Script now also sends the API key in the request body as a fallback

#### 1.5.1

 * Fixed SFTP password becoming unreadable after WordPress salt/key rotation
 * Password encryption now uses a stable plugin key instead of WordPress salts
 * Clearer admin error when the stored password must be re-entered

#### 1.5.0

 * WordPress.org initial release
 * Improved code quality based on plugin review feedback
 * Moved log storage to wp-content/uploads for better security
 * Updated WordPress compatibility to 6.9

#### 1.4.0

 * Renamed plugin to “SFTP Sync for Google Sheets” for WordPress.org compliance
 * Fixed all escaping issues (using esc_html_e, esc_html__ throughout)
 * Fixed input sanitization for $_SERVER variables
 * Updated text domain to sftp-sync-for-google-sheets
 * Removed promotional language from descriptions

#### 1.3.1

 * Removed hidden files (.htaccess) for WordPress.org plugin directory compliance
 * Logs directory now protected by index.php only (no .htaccess needed)

#### 1.3.0

 * Fixed CSV export: Now uses Google’s native CSV export instead of manual CSV building
 * This fixes WP All Import not recognizing CSV headers
 * CSV output is now identical to Google Sheets “File > Download > CSV”
 * Updated generated Google Apps Script code
 * Updated WordPress compatibility to 6.9

#### 1.2.0

 * Security: Improved password encryption using AES-256-CBC with WordPress salts
 * Security: Added rate limiting (60 requests/minute) to prevent API abuse
 * Added composer.json for easier phpseclib dependency management
 * Added index.php security files to prevent directory listing
 * Updated WordPress compatibility to 6.7

#### 1.1.0

 * Added Export Settings section in admin
 * New schedule options: Daily or Hourly
 * New filename mode: Dated (unique files) or Overwrite (same file each time)
 * Configurable base filename and export format (CSV/XLSX)
 * Apps Script now auto-configured with plugin settings
 * Improved SFTP error messages for debugging

#### 1.0.0

 * Initial release
 * SFTP upload via ssh2 or phpseclib
 * REST API endpoint for receiving files
 * Admin settings page
 * Activity logging
 * Google Apps Script generator

## Мета

 *  Версія **1.5.2**
 *  Останнє оновлення **4 тижні тому**
 *  Активних встановлень **10+**
 *  Версія WordPress ** 5.0 або вище **
 *  Tested up to **6.9.9**
 *  Версія PHP ** 7.4 або вище **
 *  Мова
 * [English (US)](https://wordpress.org/plugins/sftp-sync-for-google-sheets/)
 * Позначки
 * [automation](https://uk.wordpress.org/plugins/tags/automation/)[csv](https://uk.wordpress.org/plugins/tags/csv/)
   [Google Sheets](https://uk.wordpress.org/plugins/tags/google-sheets/)[sftp](https://uk.wordpress.org/plugins/tags/sftp/)
   [sync](https://uk.wordpress.org/plugins/tags/sync/)
 *  [Розширений перегляд](https://uk.wordpress.org/plugins/sftp-sync-for-google-sheets/advanced/)

## Оцінки

No reviews have been submitted yet.

[Your review](https://wordpress.org/support/plugin/sftp-sync-for-google-sheets/reviews/#new-post)

[See all reviews](https://wordpress.org/support/plugin/sftp-sync-for-google-sheets/reviews/)

## Учасники

 *   [ Olivier Bigras ](https://profiles.wordpress.org/bigrat95/)

## Підтримка

Є що сказати? Потрібна допомога?

 [Перейти в форум підтримки](https://wordpress.org/support/plugin/sftp-sync-for-google-sheets/)

## Пожертвування

Ви хотіли б підтримати розвиток цього плагіна?

 [ Пожертвувати на розвиток плагіна ](https://olivierbigras.com)