I suck at Google Sheets – that’s why I need you! – Upwork

Hey

You live and breathe large spreadsheets, data feeds and function? Then our gig might be perfect for you.

We are currently setting up a Google sheet to run some cannabis related product databases.

As a starter we have one small task to be delivered:

https://docs.google.com/spreadsheets/d/1pDScgsxrjwVEuzSXyr4OVzkugx9A8Lz_IxPZM5diYqk/edit#gid=1803310261
I am trying to import a csv product feed which we generate from our wordpress site

one issue I have is that the importdata function keeps providing a cached version of the feed URL. hence whenever I update the feed in wordpress, the importdata still catches an older version of the csv feed.

Your task: setup some some script that I can trigger manually in order to refresh the feed fully.

IMPORTANT: the solution has to be as simple as possible since we want remove any unnecessary complexity.

To apply for the gig, please follow the steps:
1. briefly mention your past work experience with google sheets formulas and scripts
2. let me know how long it would take to fulfill the task for you

Posted On: April 20, 2022 13:03 UTC
Category: Scripting & Automation
Skills:Google Apps Script, Integromat, Google Docs, Google Sheets

Country: Hong Kong

click to apply

Generated by Feedzy