Question

How can I upload Google sheet to FTP?

  • 29 November 2021
  • 5 replies
  • 560 views

Hello

Thanks for reading.

 

My Zapier is creating Google sheet, But I want to export that Google sheet to my FTP. Can anyone tell how can I do it?

 

Thanks


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

5 replies

Userlevel 7
Badge +14

Hi @mariodice 

Try using the Files.com Zap app integration to upload files via FTP: https://zapier.com/apps/filesdotcom/integrations

Hello @Troy Tessalone 

 

Thanks for your reply. Your message led me to some of the answers.

 

I am looking for a way to upload Google sheet to my ftp. 

 

Trigger is when any new rows are added to Google sheet then upload that Google sheet to my FTP.

 

Any idea how can I do the upload part without using Files.com? 

 

Thanks

Userlevel 7
Badge +14

@mariodice 

Zap does not have a native FTP app, so an app integration such as Files.com is usually the easiest to be used.

 

Maybe try this API: https://www.ftp-api.com/

 

App APIs can be used in Zaps with the Webhooks app or Code app.

Webhooks: https://zapier.com/apps/webhook/integrations

Code: https://zapier.com/apps/code/help

Thanks @Troy Tessalone 

In your last reply you have mentioned about webhooks which is above my level so I have been trying to take no code route.

 

I have been playing around with zap and after doing some testing, I have created a zap that triggers  New or Updated Spreadsheet Row in Google Sheets and saving it to my dropbox, however it passes information in data form not as in file form.

I am planning to save whole spreadsheet to my dropbox account when trigger happens, But it creates a .txt file in dropbox and saves text which has been added to spreadsheet.

 

Is it possible to save whole spreadhseet to dropbox? I played with zap but could not figure it out and there was no option to save the whole spreadsheet.

 

Thanks again for looking into my issue and replying to me.

Userlevel 7
Badge +14

@mariodice

Help article for how you use files in Zaps: https://zapier.com/help/create/basics/send-files-in-zaps

GDrive Find File will return a file object that you can use in following Zap steps.

Please post screenshots with how your Zap steps are configured, thanks.