The path from Sheet to SFTP
Who this is for
Ops, growth, and data people who already keep leads, orders, or inventory in Google Sheets, and must drop a CSV on an SFTP server for a partner or internal system.
You do not want to download manually every morning, paste into a desktop SFTP client, and hope nobody forgets. You want a small, inspectable automation with email when it succeeds or fails.
How the flow works
The tool runs on lawrencehumblet.com. You sign in with Google (read-only Sheets and Drive metadata). You choose a spreadsheet and tab, pick columns, enter SFTP details, test the connection with a tiny probe file, set a schedule and timezone, and choose who gets notification emails.
On each run the service reads the sheet, builds a comma or pipe delimited file, uploads it with a unique filename by default, and records the result in run history.
How to use it
- Sign in with Google
Open the tool and continue with the Google account that owns or can view the spreadsheet. The same account is used to list your sheets.
Step 1. Sign in with Google on the tool page. - Choose sheet, tab, and columns
Search your Drive for the spreadsheet, pick one tab, then use the columns dropdown checklist. Choose comma or pipe delimiter and whether to include a header row.
Step 2. Choose the spreadsheet, tab, and columns to export. - Enter SFTP details and test
Host, port, username, password or SSH private key, and remote folder. Test connection writes a tiny probe file and deletes it so you know write access works before you schedule anything.
Step 3. Enter SFTP details and test with a probe file. - Schedule and notify
Exports run once daily. Pick a local time and timezone. Set the filename pattern with {date} and/or {timestamp}. Add the email that should receive success and failure alerts. You can also use Run once now any time.
Step 4. Set the daily schedule, notifications, then save and run once. - Save, then run once
Save the schedule, then use Run once now to verify end to end. Check run history on the page and the confirmation email. The schedule panel above shows where those actions sit.
Free limits and upgrades
Free: one Google account, one saved schedule, up to 10,000 data rows per export. Run once is allowed whenever you stay under the row cap. Sheets over 10,000 rows hard-fail until you upgrade.
Upgrade requests are $49 per month for up to 1M rows and unlimited scheduled runs.
Security notes
Google access is OAuth with read-only Sheets and Drive metadata scopes. SFTP passwords and private keys are encrypted at rest. Schedules keep running even if you do not log in for 90 days; revoke Google access or sign out and delete credentials if you need to stop.
Prefer an SFTP user scoped only to the inbound folder you need. Rotate credentials if a partner changes servers.
FAQ
- Can I export Google Sheets to SFTP automatically?
- Yes. Sign in with Google in the Sheets CSV to SFTP tool, save SFTP details, set a once-daily time and timezone, and the site runs the export for you. You can also trigger a one-off run anytime.
- Does it support CSV and pipe-delimited files?
- Yes. You can choose comma (CSV) or pipe (|) as the delimiter, and optionally include a header row.
- How do I know the SFTP connection works?
- Use Test connection. The tool writes a small probe file to your remote path and deletes it. Only then should you save a schedule.
- What happens if the upload fails?
- The run is marked failed in history. If you enabled failure emails, you get a message that includes the error text.
- Is this free?
- Yes to start: one schedule and up to 10,000 rows. Larger sheets or more schedules need an upgrade request at $49 per month.
Start here
Configure the export in the tool. If you need something adjacent built into your stack, use the feedback form on the tool page or get in touch.