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

I have the same setup and am running into the same issue. I found that Perplexity is getting the links but it can’t follow the Google News URLs because they are redirecting. I am trying to create a new column in my google sheet that converts the scraped Google News Links into their final destination. That way Perplexity will be able to read the urls and do the summaries. I am having trouble getting the Google sheet formula to convert the google news links but this is what I am trying to convert the links.

My steps are:

    • Open the Script Editor:
  • Go to your Google Sheet.
  • Click on Extensions > Apps Script.
  • Create the Function:
  • Paste the following script into the editor:
function getFinalURL(url) {
  try {
    var response = UrlFetchApp.fetch(url, { followRedirects: false });
    var headers = response.getHeaders();
    if (headers['Location']) {
      return headers['Location'];
    } else {
      return url;
    }
  } catch (e) {
    return "Error: " + e.message;
  }
}
  • Save and Authorize the Script:
  • Save the script (e.g., name it “Unshorten URLs”).
  • Click the disk icon or press Ctrl + S.
  • When you first use the script, Google will ask for permissions. Click Authorize and follow the steps.
  • Use the Custom Function in the Sheet:
  • Return to your Google Sheet.
  • Assume the short URLs are in column A, starting at row 2.
  • In column B2, enter the formula:

plaintext

Copy code

=getFinalURL(A2)
  • Drag the formula down to apply it to other rows.

Please respond if you end up getting this to work. If I find another way or get this to work I will post it.