Question

How do I download an external URL hosted by sftp and import into a Google sheet on an ongoing basis?

  • 2 August 2022
  • 2 replies
  • 231 views

I have an external facing file that needs to be downloaded into Google Sheets on an ongoing basis.  The file is on a non-Google client server.  I want to be able to have this process trigger once per hour -

 

Downloads csv file from url

File gets parsed into existing Google Sheet

The file each time replaces everything in the google sheet except for the headers.  

There are 2000 lines of data in about 12 columns. 

The Google Sheet shared URL cannot change.  

 


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

2 replies

Userlevel 7
Badge +14

Hi @contextu 

Good question.

You may want to consider using GAS (Google Apps Script) for this.

https://developers.google.com/apps-script

Userlevel 7
Badge +9

Hey @contextu just checking in here! Were you able to try out Troy’s recommendation of using a Google Apps Script to accomplish your desired workflow? Let us know! We’d love to know how you’re doing with getting this set up!