Googlesheet export as csv overwrite daily > publish to sftp site

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
    

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)

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 Zaps: https://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!