EasyFTP to Formatter to Google Sheets - Replace All Rows When New File Drops

I have tried setting up a Zap to grab a file from and SFTP and upload all rows to a Google Sheet.

I am using Easy FTP as the file location. I selected “new file in folder” as the event. I then use Formatter by Zappier (utilities) to format the CSV. I then used Google Sheets with the action Update Spreadsheet Row(s) to Google Sheets but I only get it to update one row because it requires a row number.

The report I am dropping on the SFTP has over 500 lines (but less than 1000). The idea is that when the file drops (once a day) the google spreadsheet will be updated will all new rows replacing prior ones.

I have tried some of the line item options but still cannot make it work.

Page 1 / 1

Hi @Sagtavo

Good question.

You would have to use the GSheet API: https://developers.google.com/sheets/api/guides/concepts

Try using the AI in this Zap action: GSheets - App Extensions

You’ll need to first delete the desired rows in the GSheet.

Then you can try to use this Zap action: GSheets - Create Row(s)

I have set-up the below Zap. It is to be triggered when a new file is placed on the designated SFTP folder. When I test it, it works; 50 rows get populated as part of the test. However, when the file is dropped on the SFTP, it is not triggering. Not sure why. I have scheduled the CSV filed to be dropped a few times and I see it in the SFTP, but the Zap doesn’t trigger. Even when I try to trigger is manually, it doesn’t. What am I missing?

@Sagtavo

You don’t need step 3 since step 4 handles line items.

Try reaching out to EasyFTP Support.

EasyFTP help articles:

https://www.easyftp.io/docs/zapier

https://zapier.com/apps/easyftp/help

Connect to EasyFTP on Zapier

EasyFTP uses OAuth to authenticate your account on Zapier.

Log into EasyFTP to authenticate.
Grant Zapier permission to access your account if prompted to.

Learn more about authenticating your EasyFTP account in Zapier.

About EasyFTP's app

Are self-hosted or cloud-hosted accounts supported?	Cloud-hosted accounts only
Is a paid EasyFTP plan required?	No	View EasyFTP's plans.
Are any special account permissions required?	No
Are there usage limits?	No
Are there pagination limits?	No
Do trigger samples use real data from your account or generic data?	Real trigger samples
Are custom fields supported?	No
Do update actions overwrite or append to existing data?	Not applicable
Is there any additional info?	Yes	For Zapier Team or Company users, you can use a Static IP address to connect to Zapier.

So I removed the extra step. I ran a test and it is populating the 50 rows as part of the test. However, after publishing it, it is giving me this error.