We have a client that publishes press releases via Cision. https://www.cision.com/us/
We need to have an automated process that opens the list feed (JSON/XML), goes to the linked detail feed and pulls data into a Google Sheet or AirTable.
Data Needed:
- Release Name
- Publish Date
- Description
- Encrypted ID
- Cision ID
- Regulatory (YES/NO)
We want this to be published to a google sheet so we can have it then be sent to our Webflow CMS so that the press releases can be published automatically.
Our main sticking point right now is consolidating the data from the List feed and detail feed in one source so it can be imported to our CMS. The previous Website has a corn function running on a Wordpress site to accomplish this.
Here is an example of the Website we are doing manually now.
We will need this done for two replicated feeds, one English and the other Swedish.
Budget: $500
Posted On: October 29, 2020 19:45 UTC Category: Scripting & Automation Skills:API Integration, Automation, Data Extraction, Scripting, Integromat, Google Sheets, Zapier, JSON, XML
Skills: API Integration, Automation, Data Extraction, Scripting, Integromat, Google Sheets, Zapier, JSON, XML Country: Canada
click to apply
Project ID:
3095102
Project category:
API Integration, Automation, Data Extraction, Scripting, Integromat, Google Sheets, Zapier, JSON, XML