Question

Googlesheet export as csv overwrite daily > publish to sftp site

  • 29 March 2023
  • 5 replies
  • 430 views

I have a googlesheet which
I need to export daily as a csv overwrite on a google drive
and post it to a sftp server

 

Appreciate any help

 


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 4
Badge +6

Hi @ZoloT 

Welcome to the Community!

To help you further on this and be able to suggest workarounds, do you have a specific use case that I could help out with? If you can phrase it in the “When A happens in Service X, B should happen in Service Y” format, that’ll help me make sure I give you the best suggestion possible, so thank you in advance!

I want to make sure we're on the same page so I can point you in the right direction!

 

Hi @Brem,

  1. When Schedule by Zapier is trigger time: midnight
  2. in Google Sheets: Find MyWorksheet
  3. Export MyWorksheet as csv to Google Drive
  4. In google drive: Find MyWorksheet.csv
  5. In EASYFTP: Publish MyWorksheet.csv
     
Userlevel 7
Badge +6

Hey there @ZoloT,

I’m jumping in to see if I can help!

Here is how I see the Zap for the workflow that you have in mind:

  1. Trigger: Schedule by Zapier
  2. Action: Google Drive (Find a File)
  3. Action: EasyFTP (Upload a File)

Would this help you out? Please let me know if you have any questions.

Thanks! 😊

Thanks @ken.a !

Almost there - not sure how to do step 2

  1. Trigger: Schedule by Zapier
  2. How do I open a googlesheet > export to csv
  3. Action: Google Drive (Find a File)
  4. Action: EasyFTP (Upload a File)
Userlevel 7
Badge +8

Hi @ZoloT I did some searching and found a previous response on a similar request from the past

Use the GDrive Find File action step in the Zap to get the CSV version of the GSheet.

Using Files in Zapshttps://zapier.com/help/create/basics/send-files-in-zaps

Does this help fulfil your request? Let me know, happy to come back and keep working on this!