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:
-
- 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.