Trying to get good sheet data (news article) into perplexity to do an article summary

What are you trying to achieve?

I want to do SM post from a list of articles in a Google sheet row. I want to do a daily post. Perplexity does not pick up the data (link) from the row in the google sheet

Steps taken so far

I repeated the process many times. Everything is hooked up. But the output is not the target article. Its something about AI.

Screenshots: scenario setup, module configuration, errors

What are your mapping in the perplexity module? Also what are the outputs of the google sheet module?

The trigger is a google sheet. A link to a news article. Google sheets connects, and identifies the link , but perplexity receives it a “empty”. I want perplexity to summaries the article, and pass it over to create a SM post.

Do I need to manually pass google ID’s and Oath api to make this happen? I have tried tht but difficult to fugure out on the Google side