IMPORTFEED Function: Consolidate Multiple Google Alerts Into a Single Google Sheets File
8.1 هزار بار بازدید -
6 سال پیش
-
How to use the IMPORTFEED
How to use the IMPORTFEED function to import multiple Google Alerts into a Google Sheets spreadsheet. Detail on the functions referenced in the video:
IMPORTFEED:
=IMPORTFEED(A1,"items title", TRUE, 100)
=IMPORTFEED(A1,"items URL", TRUE, 100)
=IMPORTFEED(A1,"items created", TRUE, 100)
Social Sharing (these are subject to change at any time by the social media platform vendors):
Twitter
=hyperlink("https://twitter.com/intent/tweet?text="&A4&"+"&B4&"", "Tweet")
LinkedIn
=hyperlink("https://www.linkedin.com/cws/share?url="&B4&"", "LinkedIn")
Facebook
=hyperlink("https://www.facebook.com/share.php?u="&B4&"", "Facebook")
Buffer
=hyperlink("https://bufferapp.com/add?url="&B4&"&text="&A4&"", "Buffer")
To visit our Google Workspace blog, click the link on our channel page — @GoogleWorkSpaceInfo
IMPORTFEED:
=IMPORTFEED(A1,"items title", TRUE, 100)
=IMPORTFEED(A1,"items URL", TRUE, 100)
=IMPORTFEED(A1,"items created", TRUE, 100)
Social Sharing (these are subject to change at any time by the social media platform vendors):
=hyperlink("https://twitter.com/intent/tweet?text="&A4&"+"&B4&"", "Tweet")
=hyperlink("https://www.linkedin.com/cws/share?url="&B4&"", "LinkedIn")
=hyperlink("https://www.facebook.com/share.php?u="&B4&"", "Facebook")
Buffer
=hyperlink("https://bufferapp.com/add?url="&B4&"&text="&A4&"", "Buffer")
To visit our Google Workspace blog, click the link on our channel page — @GoogleWorkSpaceInfo
6 سال پیش
در تاریخ 1397/06/27 منتشر شده
است.
8,137
بـار بازدید شده