Sennheiser, Logitech, Timex and more: Tech launches in April 2022

From a soundbar that can split into two, to a business mouse that comes in multiple sizes, April has seen a number of products launch across categories like audio, wearables, smartphones and more. Here are all the top tech launches of April 2022 so far.

From smartwatches to TTWS earbuds and soundbars, here are the tech launches of April 2022 so far. (Image Source: Timex, Sennheiser, Boult Audio)

Portronics Pure Sound 103

The Portronics Pure Sound 103 is a 100W soundbar with a built-in subwoofer. This soundbar also comes with a unique feature that lets you detach it from the middle and turn it into two soundbars, which can be placed in different areas. Connectivity options include Bluetooth, USB, and optical port. The 2.1 channel soundbar also comes with an LED display. It is priced at Rs 5,999 and can be purchased from the Portronics website and Amazon India.

Boult Audio AirBass ENCore X and AirBass XPods Pro

The Boult Audio AirBass ENCore X is a pair of TWS earbuds that comes with a quad microphone setup Type C fast charging and a playback of 30 hours. The earbuds also offers 100 minutes of playtime with just 10 mins of charging. Other features include Bluetooth 5.1 support, IPX5 water resistance, and extra soft silicone tips. The price of the earbuds is Rs 1,799 and can be purchased from the Boult Audio website and Amazon India.

The Boult Audio AirBass XPods Pro is a pair of ENC (Environmental Noise Cancelling) earbuds that come with Type-C fast charging, 24 hours of music playback, and also offers 100 minutes of playback in 15 mins of charging. The earbuds are priced at Rs 1,199.

Sennheiser CX, CX Plus TWS earbuds

Sennheiser has announced the CX-series of TWS earbuds that come with high-fidelity stereo sound. The earbuds can be controlled via the Sennheiser Smart Control App and built-in equaliser on both the earbuds. The CX TWS earbuds offer 24 hours of playback while the CX Plus offer 27 hours of playback. Other features include IPX4 water resistance, dual microphones Bluetooth 5.2 support, support for SBC, AAC, aptX, and aptX Adaptive codecs and touch controls.

The Sennheiser CX Plus TWS earbuds is priced at Rs 14,990 and CX TWS earbuds are priced at Rs 10,990. They can be purchased from the Sennheiser website and Amazon India.

Timex Fit 2.0

The Timex Fit 2.0 smartwatch comes with a 1.72-incch touchscreen display with 360×385 resolution, Bluetooth calling, SpO2 monitor, and heart rate monitor along with multiple watch faces and a 7-day battery life. The watch also features blood-pressure tracking and sleep tracking along with 20 sports modes. It is priced at Rs 5,995.

Logitech Signature M650 L, M650 Wireless mouse

The Logitech Signature M650 series include a wired (M650 L) and a wireless (M650 Wireless) edition. The business mouse comes with comfortable ergonomics, and is available in two different sizes and a left-handed variant. It comes with features like SmartWheel scrolling and near-silent clicking.

The Signature M650 Wireless is available in off-white, graphite and rose colours while the M650 L is only available in graphite. The mouse works with Windows, macOS, Linux, Chrome OS, iPadOS and Android systems. Users can also connect the mouse with Bluetooth LE or Logi Bolt USB receiver. Both the wired and the wireless variants are priced at Rs 2,995.

China approves first new gaming titles in nine months

BEIJING, April 12 — China yesterday approved its first batch of new video game licenses in nine months, ending a lengthy freeze that sent jitters through the world’s largest gaming market.

Beijing moved against its vibrant gaming sector last year as part of a sprawling crackdown on tech giants, capping the amount of time children could spend playing games and slowing approvals for new titles. — AFP pic

Beijing moved against its vibrant gaming sector last year as part of a sprawling crackdown on tech giants, capping the amount of time children could spend playing games and slowing approvals for new titles.

But yesterday the National Press and Publication Administration said it had approved 45 titles of new games — the first since July last year, according to its website.

During the tech crackdown, hundreds of game makers pledged to scrub “politically harmful” content from their products and enforce curbs on underage players in a bid to comply with government demands.

But the moves struck hard at many companies’ bottom lines, including Chinese domestic giant Tencent, which was told it had to gain government approval before releasing any new apps or updates.

The gaming titan — the maker of the wildly popular Honour of Kings — posted its slowest revenue growth since 2004.

Neither Tencent nor rival NetEase appeared on the list of newly-approved games yesterday.

But overseas Chinese tech stocks still soared in pre-market trading, with Nasdaq-listed NetEase briefly jumping over eight per cent.

Video-sharing site Bilibili rocketed by over nine per cent on the same bourse, while New York-listed Huya rose eight per cent.

China’s ruling Communist Party has relied on success stories like Tencent to push a digital transformation in the country, with the biggest domestic apps seamlessly integrated into the lives of hundreds of millions.

But Beijing turned on the sector as concerns mounted over allegations of monopolistic practices and data abuse, as well as reining in the entertainment industries. — AFP

Indexing: A tale of two search engines

In Part 7 of our Messy SEO series, we look at the differences between Bing and Google’s indexing of MarTech’s content.

Messy SEO is a column covering the nitty-gritty, unpolished tasks involved in the auditing, planning, and optimization of websites, using MarTech’s new domain as a case study.

This installment of “Messy SEO” details my process of working with our team to analyze indexing patterns for MarTech’s pages. In Part 6, we discussed the necessity of creating pillar pages to establish a better site hierarchy and rank for our most relevant topics.

RELATED: Google lets you report an indexing issue

MarTech.org has had many indexing issues since its creation last year. The most pressing one lately is that Google seems to be prioritizing outdated content in the SERPs, meaning many of the (now redirected) Marketing Land and MarTech Today URLs are still populating the index. As a result, the majority of MarTech’s top-performing pages are irrelevant to our brand as it exists today. 

One of the ways we’re addressing this issue is by creating pillar pages that center on the main industry topics we cover at MarTech. This will help us establish a hierarchy of relevant topics.

We’ve primarily focused on Google’s indexation throughout this process, neglecting to review the ways other search engines have treated our content. So, we decided to compare the MarTech, Marketing Land, and MarTech Today data from Google with that from Microsoft Bing – and the discrepancies were telling.

Indexing status almost a year after migration and consolidation

There have been a lot of changes to MarTech’s indexing since the migration, most notably the title change issues. Thankfully, these were largely resolved, but there are some other issues we found when comparing the content indexed on Google and that on Bing.

Google’s indexing

Despite many lingering indexing issues, Google has made some adjustments to MarTech’s indexation over the past year. The search engine removed virtually all of our duplicate URLs after we set up our redirects, and a good portion of Marketing Land and MarTech Today pages have been removed as well. However, we’ve recently noticed some interesting performance and indexing trends.

Performance. The majority of the top pages from the past three months in terms of interaction are legacy pages that have little to no relevance to our MarTech brand. Aside from the homepage, the “What is MarTech” page, and our CDP platform page, the top URLs are largely irrelevant to our target audience.

Page Impressions Clicks Avg. Position

/ 590170 13778 25.34

/content-marketing-done-right-8-examples-can-learn/ 529481 7429 30.13

/top-10-payment-processing-companies-world/ 717026 7259 32.48

/what-is-martech/ 278783 6773 11.33

/8-companies-social-media-right-marketers-can-learn/ 251427 5087 48.91

/martech-landscape-customer-data-platform/ 369856 3882 23.16

/100-questions-you-must-ask-when-developing-web-site/ 77152 3580 27.66

/10-steps-target-connect-potential-customers-effectively/ 170443 3353 20.48

MarTech’s top-performing pages on Google.

Granted, these articles have been live for years, building up authority on the Marketing Land and MarTech Today domains. But, after almost a year of MarTech being live, it’s odd that there are so many old, less relevant pages sitting at the top of our performance lists – especially when our team has published so much good content since then.

Indexed pages. Google has roughly 29,000 MarTech URLs in its index. The majority of these are relevant links we’ve placed in our sitemaps. However, there are over 7,000 URLs in the “Indexed, not submitted in sitemap” category. Many of these URLs are irrelevant — a disconcerting number have parameters that look like either tracking code or, in some cases, spam.

 

URLs with parameters in the index.

The prevalence of URL parameters isn’t surprising, but it’s not clear why Google is including so many of these in the index. The more alarming trend, however, is the number of Marketing Land and MarTech Today URLs that are still in Google’s index as well.

Marketing Land URLs on Google.

MarTech Today URLs on Google.

We know that there are plenty of Marketing Land and MarTech Today URLs online, both in our older pieces of content and on other websites. But it’s strange to see so many still in Google’s index.

Bing’s indexing

Bing’s indexing tells a different story. Though there are still plenty of irrelevant content pieces, they’re much less prominent in the SERPs.

Performance. MarTech’s top-performing pages on Bing look somewhat similar to those on Google. The homepage, “What is MarTech” page, and legacy pages are still there, but we also found one of our more recent news articles in the mix. The importance of the piece to our industry undoubtedly helped bring it to the forefront, but it’s peculiar that Google didn’t treat it the same way.

Page Impressions Clicks Avg. Position

/ 1.2k 119 4.75

/10-steps-target-connect-potential-customers-effectively/ 586 27 5.99

/100-questions-you-must-ask-when-developing-web-site/ 231 17 4.96

/whats-big-idea-3-fundamentals-successful-digital-creative/ 408 14 5.36

/what-is-martech/ 613 14 5.04

/top-10-payment-processing-companies-world/ 4.6k 11 7.51

/5-roles-need-marketing-team-2-roles-havent-thought/ 132 10 7.73

/google-to-end-universal-analytics-in-2023/ 40 8 3.55

MarTech’s top-performing pages on Bing.

This newer article’s numbers are encouraging, but, just like the results on Google, our more relevant topic pages are failing to perform well.

Indexed pages. Bing has indexed fewer of our MarTech pages (roughly 17,000 URLs), which isn’t surprising, given how much smaller it is than Google. However, after analyzing these URLs, we found the ratio of relevant content to irrelevant content to be much lower. We’re not seeing a huge number of indexed URLs with parameters.

The most glaring difference between the two search engines is their indexing of our old domain pages. While Google still retains over 2,000 URLs from Marketing Land and MarTech Today, there are only 143 of these URLs left in Bing’s index.

Yes, Bing had fewer of these pages to begin with, but the inconsistency is still shocking.

A discrepancy between Google and Bing’s indexing

Of the two search engines, it seems Bing is doing a better job of crawling our old URLs and adjusting its index accordingly. This makes sense — there are fewer pages indexed on Bing, so the search engine has less to clean up.

But why is Google holding on to so many of these old URLs? One possible explanation is that it simply hasn’t crawled all of the old URLs yet. This would mean it hasn’t found the 301 redirects we put in place, believing the old sites are still live.

This seems unlikely, however, as we migrated the site almost a year ago. Google has had plenty of time to crawl our pages. Yet, we’re still open to this possibility.

Another explanation could be that there’s a structural issue on the MarTech site that is somehow telling Google the old domains are still live. We’re conducting some deep technical audits at the moment to determine if this is true. Until we know more, we’re going to continue to create good content and do all we can to help it rank higher than the less relevant pages.

Have you noticed discrepancies in indexing between Google and Bing? How are you addressing the issue? Email me at cpatterson@thirddoormedia.com with the subject line “Messy SEO Part 7” to let me know.

Google March 2022 product reviews update is finished rolling out

 Almost three weeks after Google launched the 3rd version of the product reviews update, it is now done rolling out.

Google has confirmed that the March 2022 product reviews update is now finished rolling out. This update, announced on March 23, has officially completed rolling out over a 19 day period.

The announcement. “The Google product review update is fully rolled out. Thank you!” Google’s Alan Kent wrote on Twitter.

March 2022 product reviews update. As a reminder, the March 2022 product reviews update started to roll out at about 12 p.m. ET on March 23. This update took 19 days to roll out after it was announced. So this update started on March 23 and lasted through April 11.

Big update. This update was not as big as the December 2021 update, based on data from the data providers.

Why we care. If your website offers product review content, you will want to check your rankings to see if you were impacted. Did your Google organic traffic improve, decline or stay the same?

Long term, you are going to want to ensure that you put a lot more detail and effort into your product review content. Make it unique so it stands out from the competition on the web.

More on the March 2022 products reviews update

The SEO community. The March 2022 product reviews update seemed to have a slow start, with some volatility as early as March 23 but then most of the volatility showed up on March 31. I was able to cover the community reaction in one blog post on the Search Engine Roundtable. It includes some of the early chatter, ranking charts and social shares from some SEOs. In short, if your site was hit by this update, you probably felt it in a very big way but this was not as widespread as the December update in terms of the chatter within the community.

What to do if you are hit. Google has given advice on what to consider if you are negatively impacted by this product reviews update. We posted that advice in our original story over here. In addition, Google provided two new best practices around this update, one saying to provide more multimedia around your product reviews and the second is to provide links to multiple sellers, not just one. Google posted these two items:

Provide evidence such as visuals, audio, or other links of your own experience with the product, to support your expertise and reinforce the authenticity of your review.

Include links to multiple sellers to give the reader the option to purchase from their merchant of choice.

Google added the following criteria for what matters with the March 2022 product reviews update:

Include helpful in-depth details, like the benefits or drawbacks of a certain item, specifics on how a product performs or how the product differs from previous versions

Come from people who have actually used the products, and show what the product is physically like or how it’s used

Include unique information beyond what the manufacturer provides — like visuals, audio or links to other content detailing the reviewer’s experience

Cover comparable products, or explain what sets a product apart from its competitors

Google added three new points of new advice for this third release of the products reviews update:

Are product review updates relevant to ranked lists and comparison reviews? Yes. Product review updates apply to all forms of review content. The best practices we’ve shared also apply. However, due to the shorter nature of ranked lists, you may want to demonstrate expertise and reinforce authenticity in a more concise way. Citing pertinent results and including original images from tests you performed with the product can be good ways to do this.

Are there any recommendations for reviews recommending “best” products? If you recommend a product as the best overall or the best for a certain purpose, be sure to share with the reader why you consider that product the best. What sets the product apart from others in the market? Why is the product particularly suited for its recommended purpose? Be sure to include supporting first-hand evidence.

If I create a review that covers multiple products, should I still create reviews for the products individually? It can be effective to write a high quality ranked list of related products in combination with in-depth single-product reviews for each recommended product.  If you write both, make sure there is enough useful content in the ranked list for it to stand on its own.

Google product reviews update. The Google product reviews update aims to promote review content that is above and beyond much of the templated information you see on the web. Google said it will promote these types of product reviews in its search results rankings.

Google is not directly punishing lower quality product reviews that have “thin content that simply summarizes a bunch of products.” However, if you provide such content and find your rankings demoted because other content is promoted above yours, it will definitely feel like a penalty. Technically, according to Google, this is not a penalty against your content, Google is just rewarding sites with more insightful review content with rankings above yours.

Technically, this update should only impact product review content and not other types of content.

How to Save Money on your Microsoft Office 365 Subscription

 Looking to buy a subscription of Microsoft Office 365 for your home or small business? Here are some tips to save money on your office 365 subscription.

The personal edition of Microsoft Office 365 is available for $6.99 per month on the official Microsoft website. This license includes all Microsoft Office apps. With the personal license, you’ll be able to install Microsoft Office on all your computers, phones and tablets through you can only be signed in to 5 device at the same time.

You may buy a license for Microsoft Office 365 through the Microsoft website, through in-app purchases inside the Apple App Store or Google Play store or through online stores like Amazon.

Office 365 Prices Comparison

I did a quick comparison of Office 365 prices across different regions and it is obvious that the most affordable option is Amazon. For instance, if you are looking to buy Microsoft 365 subscription in India, you’ll save around 20% when the purchase is made through Amazon vis-a-vis the Microsoft Store. The savings are even higher for UK customers.

• Country / Region Price on Microsoft Store Price on Amazon Website Savings
• United States $69.99 $58.99 16%
• India ₹4,899 ₹3,949 20%
• France €69,00 €59,99 13%
• United Kingdom £59.99 £42.99 28%

Buying Office 365 through Amazon

When you buy a Microsoft 365 subscription through Amazon, Amazon will send a 16-digit license key to the email address associated with your Amazon account. It may take 15-30 minutes for the license key to arrive.

Once you have received the code, go to setup.office.com and sign-in with the Microsoft Office where you wish to use the Office 365 subscription. Enter the product key and click on the “Activate” button.

Next, launch Word, Outlook or any other Microsoft Office app on the computer and sign-in with the same Microsoft account.

Also see: Buy Udemy Courses for Less

Things to note

The Office 365 subscription purchased on Amazon is exactly the same as the one offered on the Microsoft website but the price is cheaper. Once the license is activated, you’ll manage the subscription through your Office.com dashboard.

There are a few things to note when you buy an Office 365 license outside the Microsoft store.

1. There could be geo restrictions in place. For instance, an Office license acquired from the Amazon US website may not be activated in India.
2. If you wish to opt for monthly billing instead of paying for the full year, you’ll have to buy through the Microsoft website or make an in-app purchase on your Android or iPhone.
3. This is important. If you have purchased Office 365 from Microsoft, you can request a return but licenses purchased through Amazon may not be returnable in every region.

View Microsoft Office Files in the Browser without Downloading

 Office Web Apps Viewer and Google Drive Viewer can come handy when you don't have any Office suite installed on your computer or when you would like to quickly preview any online Office file in the browser without having to download it locally.

You can use the filetype: operator in Google to search for Office files of specific types. For instance, a query like invoice template filetype:xls will find public Excel spreadsheets that match the search query. Similarly, you can find Word documents and PowerPoint presentations on the Internet by appending filetype:doc or filetype:ppt to the search query.

How do you view a file that you found on the Internet in the browser itself?

All modern browsers have built-in support for PDF files so you can view them directly in the browser without downloading the file to your computer. However, if you are working with Office files, you can use simple URL hacks to view the file inside Google Docs or Microsoft Office Viewer.

View Office Files in Browser

We’ve two sample files, an Excel spreadsheet and a Word file, hosted on the Internet. The file URLs are provided below and the requirement is to view these files directly in the browser.

https://www.labnol.org/files/word.docx [Word document]

https://www.labnol.org/files/excel.xlsx [Excel spreadsheet]

Google Drive Viewer

Google Drive includes a built-in viewer feature that allows you to view Office files directly in the browser without downloading them. The files are streamed from the hosting website and not uploaded to your Google Drive either.

To view the file, replace FILE_URL with the link of the file you want to view 

https://drive.google.com/viewer?url=FILE_URL

If you would like to embed an Office file in your website with the Google Drive viewer, the HTMl would be as below. You would need to replace the actual URL of the document and may also adjust the height and width attributes of the IFRAME tag.

<iframe

  src="https://drive.google.com/viewer?embedded=true&hl=en-US&url=FILE_URL"

  width="500px"

  height="350px"

  frameborder="0"

></iframe>

Microsoft Office Viewer

Similar to Google Drive Viewer, Microsoft Office also offers a online document viewer to help you to view Word documents, Excel Spreadsheets and PowerPoint decks directly in the browser without downloading them.

Simply replace FILE_URL with the URL of the Office file. 

https://view.officeapps.live.com/op/view.aspx?src=FILE_URL

In addition to previewing Office files, the Office Web Apps Viewer tool can also be used for embedding Microsoft Office documents into your website or blog. The embed code would be something like this:

<iframe

  src="https://view.officeapps.live.com/op/embed.aspx?src=FILE_URL"

  width="500px"

  height="350px"

  frameborder="0"

></iframe>

While Office Web Apps viewer is definitely a better option that Google Docs Viewer, a limitation is that it only works with Office Files, Google Drive Viewer can also handle PDFs, Photoshop files and even AutoCAD drawings.

 

 

 

How to Import PayPal Transactions into Google Sheets

Learn how to easy import transactions from PayPal into Google Sheets with Google Apps Script. You can import standard transactions, recurring subscriptions and donations.

This tutorial will show you how to import PayPal transactions into Google Sheets with the help of Google Apps Script. You can choose to import standard PayPal payments, recurring subscription payments, donations, or even refunds and chargebacks into Google Sheets.

Once the data has been imported into Google Sheets, you can export them into a CSV file and import them into Quickbooks accounting software. Tally users in India can export PayPal transactions from Google Sheets into XML format and bulk import them into Tally.

Also see: Automate PayPal with Google Forms

Import PayPal Transactions in Google Sheets

For this example, we will be importing the list of donors into Google Sheets who have made the donations through PayPal.

1. Create API credentials inside PayPal

Sign-in to your PayPal developer dashboard (developer.paypal.com) and create a new app in the live mode. Give your App a name - Transaction Importer for Google Sheets and click the Create App button.

PayPal will create a Client ID and Client Secret key that you will need in a later step. Under the Live App settings section, check the Transaction Search option and turn off all other options since we only want the API keys to list transactions and have no other functionality. Click Save to continue.

2. Create a Google Sheets Project

Go to sheets.new to create a new Google Sheet. Go to Extensions menu and choose Apps Script to open the Apps Script editor.

Copy-paste the code in the editor. Remember to replace the transaction code with your own. You can use T0002 for PayPal Subscriptions, T0014 for Donation payments, or T1107 for PayPal Refunds and chargebacks.

The /* @OnlyCurrentDoc */ comment is a Google Apps Script comment that tells Google Apps Script to only run the code inside the current Google Sheet and not require access to any another spreadsheet in your Google Drive.

/* @OnlyCurrentDoc */

/* Author: digitalinspiration.com */

const TRANSACTION_TYPE = 'T0001';

// Enter your own PayPal Client ID and Client Secret key

const PAYPAL_CLIENT_ID = '<YOUR_PAYPAL_CLIENT_ID>';

const PAYPAL_CLIENT_SECRET = '<YOUR_PAYPAL_CLIENT_SECRET>';

// Enter start and end dates in the format YYYY-MM-DD

const START_DATE = '2022-03-01';

const END_DATE = '2022-03-15';

// Generate the PayPal access token

const getPayPalAccessToken_ = () => {

  const credentials = `${PAYPAL_CLIENT_ID}:${PAYPAL_CLIENT_SECRET}`;

  const headers = {

    Authorization: ` Basic ${Utilities.base64Encode(credentials)}`,

    Accept: 'application/json',

    'Content-Type': 'application/json',

    'Accept-Language': 'en_US',

  };

  const options = {

    method: 'POST',

    headers,

    contentType: 'application/x-www-form-urlencoded',

    payload: { grant_type: 'client_credentials' },

  };

  const request = UrlFetchApp.fetch('https://api.paypal.com/v1/oauth2/token', options);

  const { access_token } = JSON.parse(request);

  return access_token;

};

// Append the query parameters to the PayPal API URL

const buildAPIUrl_ = (queryParams) => {

  const baseUrl = [`https://api-m.paypal.com/v1/reporting/transactions`];

  Object.entries(queryParams).forEach(([key, value], index) => {

    const prefix = index === 0 ? '?' : '&';

    baseUrl.push(`${prefix}${key}=${value}`);

  });

  return baseUrl.join('');

};

// Fetch the list of PayPal transaction

const fetchTransactionBatchFromPayPal = (queryParams) => {

  const options = {

    headers: {

      Authorization: `Bearer ${getPayPalAccessToken_()}`,

      'Content-Type': 'application/json',

    },

  };

  const request = UrlFetchApp.fetch(buildAPIUrl_(queryParams), options);

  const { transaction_details, total_pages } = JSON.parse(request);

  return { transaction_details, total_pages };

};

// Extract the transaction details including the transaction ID,

// donation amount, transaction date and buyer's email and country code

const parsePayPalTransaction_ = ({ transaction_info, payer_info }) => [

  transaction_info.transaction_id,

  new Date(transaction_info.transaction_initiation_date),

  transaction_info.transaction_amount?.value,

  transaction_info.transaction_note || transaction_info.transaction_subject || '',

  payer_info?.payer_name?.alternate_full_name,

  payer_info?.email_address,

  payer_info?.country_code,

];

const fetchPayPalTransactions_ = () => {

  const startDate = new Date(START_DATE);

  const endDate = new Date(END_DATE);

  startDate.setHours(0, 0, 0, 0);

  endDate.setHours(23, 59, 59, 999);

  const transactions = [];

  const params = {

    start_date: startDate.toISOString(),

    end_date: endDate.toISOString(),

    page_size: 100,

    transaction_type: TRANSACTION_TYPE,

    fields: 'transaction_info,payer_info',

  };

  for (let page = 1, hasMore = true; hasMore; page += 1) {

    const response = fetchTransactionBatchFromPayPal({ ...params, page });

    const { transaction_details = [], total_pages } = response;

    transaction_details.map(parsePayPalTransaction_).forEach((e) => transactions.push(e));

    hasMore = total_pages && total_pages > page;

  }

  return transactions;

};

// Import the transactions from PayPal and write them to the active Google Sheet

const importTransactionsToGoogleSheet = () => {

  const transactions = fetchPayPalTransactions_();

  const { length } = transactions;

  if (length > 0) {

    const sheet = SpreadsheetApp.getActiveSheet();

    sheet.getRange(1, 1, length, transactions[0].length).setValues(transactions);

    const status = `Imported ${length} PayPal transactions into Google Sheets`;

    SpreadsheetApp.getActiveSpreadsheet().toast(status);

  }

};

3. Run PayPal Import Function

Inside the script editor, click the Run button to import transactions from PayPal. You may have to authorize the script since it requires permissions to connect to the PayPal API and also write data to Google Sheets on your behalf.

That’s it. If there are any PayPal transactions to import in the selected date range, the script will run and the transactions will be imported into Google Sheets.

In the next part of the tutorial, we will learn how to export the PayPal transactions from Google Sheets to an XML file for importing into Tally accounting software.