Google Sheets Apps Script / Macro

Job ID: 33328524

Budget: $30 – $250 USD

Hi, we are looking for a script that will automate a repetitive task:

Currently, we are importing a static file to Google Sheets, appending to current sheet, and adding a custom separator/delimiter. Here is the exact workflow:

File > Import > Upload > Select A File > Append to current sheet > Separator type = Custom > Custom separator = | > Import data

We would like to just press a HotKey Macro to run an Apps Script that will import this static file for us automatically.