[ad_1]
The goal is to create a page that shows a list of news articles as cards that link to the articles, and ideally would be able to color code the cards by topic, although this might be a lot to ask for. We currently keep track of news mentions in a google sheet and then copy and paste all the info individually by cell into a card block, but this takes forever and I’m wondering if there’s any software that can automate this. I would need each new row to trigger a new card added.
Seems like most google sheets > wordpress integrations show as tables, I do not want a table.
WP All Import.
You could use Ninja Tables. There is a gallery layout option and the plugin can automatically synch with Google Sheets. Reach out to the support people at Ninja Tables to ask them how you might display tables as cards. I expect you will need to use a bit of CSS or JavaScript.
Another option would be to create a custom post type to hold your data in custom fields then import the Google Sheet data into the custom post type (use WP All Import) and use a query loop block to display the data in a card. You will need to style the way each post in the loop displays to mimic your cards.